Set analysis - exclude current year AND month

[#1]

Hello,

I would like to exclude the current year AND month from my chart, but it doesn't work :

sum(

    {

        <field_month -= {"$(= month(ReloadTime()) )"}> * <field_year -= {"$(= year(ReloadTime()) )"}>

    }  

nb_seconds)

/ 60

Please help, best regards

[sushil353]

Hi,

If you are excluding the current year then what is the point to exclude the current month. it is automatically excluded.

also you can also use today() function instead reloadtime().

HTH

Sushil

[manojkulkarni]

You could have month year column then, use that as expression in set analysis to filter.

eg :  sum({<field_MY={'vCurrentMonthYear'}>} value)

or

if you have calender, then flag current month dates to some binary value so you can use that in if condition ..

sum(if(currentMonthFlag=0,value) where currentMonthFlag=1 for current month dates else 0

[#4]

Hi,

I want to exclude the month and the year only if both of them matches the reloadtime's month and year. If I only exclude the last year, i will lose all the months of the excluded year, that's not my goal.

The datetime must corresponds to the last reload datetime, not the server's datetime, this is why I use reloadtime() instead of today() function.

[nagarjuna_kotha]

Hi Patil,

I didn't get ur question.Can you explain it clearly what you want ?

Reagrds,

Nagarjuna

[neha_shirsath]

Hi,

You want to exclude only Current Day or max Reloadtime Month ??

Neha S.

[#7]

I think that your first solution should work, but I think it's dirty because I have to create a new field that I will only use for this filter.

I would like to create a set analysis with the good conditions.

[#8]

My current datetime is ReloadTime(), I want to keep all the months and years of my calendar except the month and year which correspond to ReloadTime() 's month and year.

[#9]

I want to create a Set Analysis which contain a filter on my month and year fields, because I don't want to retrieve the last period obtained thanks to ReloadTime function.

I want to retrieve all the months and years, except the month and year which correspond to ReloadTime() 's month and year.

[Anonymous]

try

sum({<field_date =- {<MonthName(today())>}>}field)