Month and Year Filter

[Anonymous]

Guys,

If I select only year or both year and month, the data should be shown only for Year. Is it possible? For Example, I have a field as MonthYear, which has a value like 'Jan 2011'. When I select even 'Jun 2011', the data to be shown only for 'Jan 2011'. Plz help..

[surendraj · Accepted solution]

Yes..you can use set expression in expression tab.

sum({<MonthYear={'Jan 2011'}>}value)

Here i considered dimension as MonthYear,measure as value..

[hemanthaanichet]

Siva,

you need to hard code it  with particular filed values. is this your requirement ??

Can you explain it little elaborate and if possible provid some sample data too

[Anonymous]

I'm showing KPI values for two widgets in my dashboard. But one widget is showing month wise KPI and the another one showing Year wise KPI. So If load data for both widgets, I'm confused. I'm loading 'MonthYear' format data i.e

Jan-2011 for both the widgets. Plz help...

[surendraj]

Try with..

Month & '-' & Year as MonthYear

[Anonymous]

It's also not working....

[hemanthaanichet]

year(monthyear) as year

month(monthyear) as month

expression

sum({<Year={'2011'},Month={'Jan'}>}value)