last n days transactions data from dataset

Question

How to show last n days transactions data from data set? My data contains login and logout time, duration, etc for teaching and non-teaching staff. I want to show transactions for last n days.

Answer 1

Hey, 

You can create a calculated column or use filter to show data for last n days transactions.

Using calculated field- create as below

IF DATEDIFF('day',[Date],TODAY()) <N THEN [Date] END

Now drop the above field in visual to see the fields as per 10 last n days.

Using filter - 

Drop the date in filter column and edit the filter as top N( for ex. 10) and select Last date where last date is a calculted field which has code MAX([Date]) to fetch the last N dates.

Hope it helps you.