Latest 7 days data in chart

[Anonymous]

Hi,

I have a table with 3 fields, products brought, price and start_date.

I have a graph, where am using "Products brought" in Dimension and "price" in Expression. I have one month of data in the chart.

i have a field called start_date,

where in the chart i need to display products brought and price of latest week (last 7 days only)

Help me to find this.

[devarasu07]

Hi Kishore,

By using dimension limit value at chart property you can able to achieve it.

Hope this will help you.

Thanks

Deva

[tresesco · Accepted solution]

Try like:

Sum({<Date={'>$(=Date(Max(Date)-7))<=$(=Date(Max(Date)))'}>}Sales)

PFA