Problem with Set Analysis and variable

[fredericvillemi]

Hi,

i have a variable called "onemonth"

=if (text(STARTDAY) > Date(NOW()-30,'YYYYMMDD'),'Yes','No')

i have a graph with STARTDAY as dimension and i want to show only the 30 last days using onemonth variable = 'Yes'

I have created this set analysis expression :

=sum({$<$(onemonth) = {'Yes'} >} PHY_READ_BYTES)

but it shows all days with good data..  If i switch Yes to No in the set analysis, it's exactly the same..

what is missing in my set analysis ??

Thanks

[lironbaram]

hei

attach is an example

may be you can use it

in the input box you can change the number of the days you want to show

[#3 · Accepted solution]

hi,

maybe u can try something like this:

=sum({$<STARTDAY= {"=text(STARTDAY) > Date(NOW()-30,'YYYYMMDD')"} >} PHY_READ_BYTES)

C u,

Stefano.