How to restrict months using 'Add calculated dimension' option?

[mallikarjun_h]

I have a field which contains 12 months.

I want only 6 months in bar chart and those are 'JAN',FEB','SEP','OCT','NOV','DEC'

Is it possible to achieve this using 'add calculated dimension' option??

If not how to get this?

[Gabriel]

Hi,

This months ('JAN',FEB','SEP','OCT','NOV','DEC') are they going to be static not changing regardless of current month users selected?

[Anonymous]

if(match(monthnamefield,'JAN',FEB','SEP','OCT','NOV','DEC') ,monthnamefield)

and then check the check boox supress when value is null for dimension that dimension

[Anonymous · Accepted solution]

use calculated dimension

if (match(yourmonthfield,'JAN',FEB','SEP','OCT','NOV','DEC')>0, yourmonthfield)

other way: restrict in Expression using set Analysis (but easier in Dimension)

also depends on whether months are static or dynamic

if dynamic, use variable to store dynamic months

[Anonymous]

hope this helps, if not please add sample document to better understand your issue

[mallikarjun_h]

Hi Rudolf,

Thanks for solution.

How can one achieve this using set analysis?

[Anonymous]

you need to put the set analysis in each expression!

e.g. sum({<month={'JAN','FEB','SEP','OCT','NOV','DEC'}>}yourvaluefield