Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expert,
I have a scenario where I have to create a trend chart showing latest 7 days date from ‘EXECUTION DATE’ field.
‘EXECUTION DATE’ fields have random date in it and I want latest 7 days data (not 7 days from today date).
Please help me on this. Thank you in Advance.
Note: I tried ‘Dimension limit’ with largest 7 days but it only shows Sep’s date data.
Best Regards,
Bhavesh
Hello,
Thank you all for your prompt reply.
Using ‘First 7 values’ instead of ‘largest 7 values’ in Dimension limits solved my issue.
BR,
Bhavesh
Hi,
Try something like..
=Sum({<[EXECUTION DATE]={">=$(=Max([EXECUTION DATE],7))"}>}Metric_Field)
Note: Date format should be in proper format
=Sum({<[EXECUTION DATE]={">=$(=Date(Max([EXECUTION DATE],7)))"}>}Metric_Field)
Hi,
Check this link for set analysis expressions for this type of scenarios
Set Analysis for certain Point in Time
=Sum({<[EXECUTION DATE]={">=$(=Date(Max([EXECUTION DATE]) - 6))"}>} MeasureName)
Hope this helps you.
Regards,
Jagan.
Hello,
Thank you all for your prompt reply.
Using ‘First 7 values’ instead of ‘largest 7 values’ in Dimension limits solved my issue.
BR,
Bhavesh