Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi,
This months ('JAN',FEB','SEP','OCT','NOV','DEC') are they going to be static not changing regardless of current month users selected?
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
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
hope this helps, if not please add sample document to better understand your issue
Hi Rudolf,
Thanks for solution.
How can one achieve this using set analysis?
you need to put the set analysis in each expression!
e.g. sum({<month={'JAN','FEB','SEP','OCT','NOV','DEC'}>}yourvaluefield