Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have created a bar chart. i have dimension Month and Day.
So my scenario is....
when i have did not select any month - the bar chart willl show me jan - dec.
when i selected Jan - it will show me 1 - 31 day of thet month , in the bar chart
How to do that with getselectedcount? like this??? if(getselectedcount(Month)=1,1,0) , doesnt seem to work
rgds,
jim
May be you need to use a calculated dimension in this case
If(GetSelectedCount(Month) = 1, Days, Month)
The above calculated dimension will show days if 1 month is selected, else it will show Month field for multiple selections in Month field or no selection in Month field.
Use like below,
if(getselectedcount(Month)>0,1,0)
Check THIS out.
May be you need to use a calculated dimension in this case
If(GetSelectedCount(Month) = 1, Days, Month)
The above calculated dimension will show days if 1 month is selected, else it will show Month field for multiple selections in Month field or no selection in Month field.