Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using a bar chart with dimension having 5 values(Total,Business,Education,IT,Other) and i used Expression as Count(value)...It shows the 5 bars in a bar chart...but i need to restrict the Total bar alone and i need to get only 4 dimension values(Total,Business,Education,IT,Other)...So any one can help.!!
Regards,
Guru
Guru - You can use the ValueList Function (Synthetic Dimension) or you can use the calculated dimension.
Or you can use Set Analysis to ignore the Total in bar chart.
SUM({$<Dimension -= {"Total"}>}Values)
I hope this helps!
Cheers - DV
Try this
Count ( {<Dimension -= {"Total"}>} Values)
hi,
For this we need to create any variable for setting the values??
Regards,
Guru
Guru,
You don’t need any variable. You can use the Set AnalysisExpression and it should work.
Cheers - DV
use expression like this:
if(sum(value)<100,sum(value))
here 100 is the value for total