daily monitoring

[master_student]

Hello lovely people,

I need to create a graph that contains the daily evolution of an indicato. Here's what I did :

The problem is that on my graph I wanna display the 5 maximum dates : 15,14,13 sep ect..

Bellow the graph properties :

Any idea please?

Thanks

[sunny_talwar]

May be use set analysis to display 5 max date instead of dimension limits

[master_student]

An example please.

[Anonymous]

Hi Wiem,

And don't show others:

Regards!

[t_moutault]

hi,

like sunny say use set analysis, something like this :

variables :

vDateDeb = Date(Max(DATE)-5,'DD/MM/YYYY')

vDateFin = Date(Max(DATE),'DD/MM/YYYY')

nb : use the format of DATE (here date is formated 'DD/MM/YYYY')

Set Analysis:

DATE={'>=$(vDateDeb ) <=$(vDateFin )'}

[Anonymous]

Hi Sunny, what happens if the dates are not consecutive?,

Max Date = '15/09/2016'

Last 5 dates:

01/09/2016, 03/09/2016, 05/09/2016, 08/09/2016, 15/09/2016

You will show only 2 dates, not 5. This is a case for limit dims.

Regards!

[master_student]

Hello Manuel, this is what I did and the result doesn't work as you can see bellow.

Thanks

[sunny_talwar]

May be something like this:

Sum({<Date = {"$(='>=' & Date(Max({<Date = {'<=$(=Date(Max(Date)))'}>}Date, 5)) & '<=' & Date(Max(Date)))"}>}Measure)

Make sure that date is created as this in the script:

LOAD Date(Date) as Date,

           ...

FROM ....

[Anonymous]

Try this then: =Sum({<Date={'>=$(=Date(FirstSortedValue(Date,-Date,5)))'}>}Value)

Regards!