Bar/Line View : Display values instead of percentages in 100% bars?

Bart · October 29, 2013 10:17AM

Is there a way to display values instead of percentages when using 100% bars? I would like to have scale in % , keep full bars (100% ) but inside the bars I would like to keep real values only.

paola · October 29, 2013 11:29AM

You can create a new formula field, calculating the value per split category e.g.
SUBSET_SUM([Value], SUBSET([Country]))
Then in the Bar/Line view choose split (here [Country]), measure [Value], stack by [Formula field], choosing Unique values and Labelled setting.
Hope this is what you tried to achieve.

Bart · October 29, 2013 12:05PM

Hi Paola,

I am using stack already, so putting formula field into stack will not work for me.

paola · October 29, 2013 12:14PM

If you are stacking by another field, so vertical bars are already split, where will the value label sit and what exactly will it display, if each bar has multiple values inside?

Bart · October 29, 2013 12:21PM

Paola,

I need something like this :

paola · October 29, 2013 12:47PM

Similar solution, but use Subset2 function...
SUBSET_SUM([Value], SUBSET2(([Country]),[Institution]))

Bart · October 30, 2013 12:50PM

Thank You Paola.

Welcome!

Categories

Ideas Parade

Tagged