Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
Sum({<Date={'>$(=Date(Max(Date)-7))<=$(=Date(Max(Date)))'}>}Sales)
PFA
Hi Kishore,
By using dimension limit value at chart property you can able to achieve it.
Hope this will help you.
Thanks
Deva
Try like:
Sum({<Date={'>$(=Date(Max(Date)-7))<=$(=Date(Max(Date)))'}>}Sales)
PFA