Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I need your help with the request below.
Source Columns : Region , Scores
Values for Region Column: North, South, East, West
I wanted to plot a bar chart to count the Scores on each region.
My dimension : Region
My expression: Sum(Scores)
Default Display is:
X axis -> 4 bars (one for North, one for South, one for East, one for West)
Y axis -> Sum of the Scores
Requirement: I want to have 5 Bar’s in the X axis, which shows the TOTAL of all 4 regions. That will be my 5th BAR of X Axis
Could you please help me in achieving this?
Thank you.
write this in your expression
dimension= Region
expression=sum(scores)
and in dimension limit-- check the total sum
see attachement
in dimension limit
check total mode
see attachement
Hello Vishwa,
Awesome.Thanks a Lot.
I normally do that for table views whenever required. But never realized that we can do it for Graphs.
It worked. Thanks again
Hi,
Just remove Total from expression in vishwaranjan's application, else its perfect for your req.
Yeah!!! Can we sort dimension for the Total Column?
I'm aware that we can write the expression on Sort tab or to pull a column for sorting.
But, Can we move the TOTAL column to the first position in the above senario?
Thanks