Visokio website     Downloads     Video tutorials     KnowledgeBase  
Bar/Line View : Display values instead of percentages in 100% bars? - Visokio Forums
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.
    100pcBarsLabelled.JPG 57K
  •     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

    I need something like this :
    Capture.PNG 8K
  •     paola October 29, 2013 12:47PM
    Similar solution, but use Subset2 function...
    SUBSET_SUM([Value], SUBSET2(([Country]),[Institution]))
    100PcBarSplit.JPG 93K
  •     Bart October 30, 2013 12:50PM
    Thank You Paola.


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership