Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expects,
I have to show count(column1) and percentage (column1) in single bar .
as you can see it should be on same bar and tool tip also fine .
i tried count in measure and percentage in color and i am getting tool tip of both but i am having same related fields charts in sheets so through out i should get same field color .so this method is not much useful .so is there any method to solve this .
thanks,
krishna
You can't show them on the bar, but you can for example , show the percentage besides the dimension, and the value on the bar:
as dimension =
YourDim&' : '& num(aggr((sum(measure) / sum(total {<YourDim>} measure)),YourDim),'# ##0,00%')
result:
You can't show them on the bar, but you can for example , show the percentage besides the dimension, and the value on the bar:
as dimension =
YourDim&' : '& num(aggr((sum(measure) / sum(total {<YourDim>} measure)),YourDim),'# ##0,00%')
result: