Show Last 5 dates

[roxys373s]

Hello,

Alright so I have a combo bar chart as shown below

I want to show  values for the last 5 dates - for example: 7/15/22, 7/16/22, 7/17/22, 7/18/22, and 7/19/22

I tried using this:

but it seems to just give me the top values in my measure. Is there anything like this that can do it for dimension so that I have the last five days instead? 

[Chandan_Nadve · Accepted solution]

Hi @roxys373s ,

You need to handle this in the  Measure level. In set analysis you need to filter for last 5 days.

I assume that your amount field is "batchamount".

Sum({<batch_date={">=$(=Date(Date(Now())-4))"}>}batchamount)

Regards

Chandan

[sidhiq91]

@roxys373s  Please use below expression in your measure.

Sum({<OrderDate={">=$(=Date(Max(OrderDate)-4))<=$(=Date(Max(OrderDate)))"}>}LineSalesAmount)

You can replace Orderdate and LineSalesAmount as per your Dimensions and Measures

If this resolves your issue, please like and accept it as a solution.

[roxys373s]

@Chandan_Nadve @sidhiq91 

Hello, 

Thank you for the possible solutions, but it still doesn't work. It ends up looking like: 

Since Im filtering for batch_date in my measure, can batch_date still be my dimension? Is that what is causing the issue? Or maybe the expression format is wrong...still trying to search it up