Latest 7 days data...

[#1]

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

[settu_periasamy]

Hi,

Try something like..

=Sum({<[EXECUTION DATE]={">=$(=Max([EXECUTION DATE],7))"}>}Metric_Field)

Note: Date format should be in proper format

[tresesco]

=Sum({<[EXECUTION DATE]={">=$(=Date(Max([EXECUTION DATE],7)))"}>}Metric_Field)

[jagan]

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.

[#5 · Accepted solution]

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