Forum Discussion

sana_sagheer's avatar
sana_sagheer
Advocate I
8 years ago
Solved

Calculation, single chart based on 3 measures

I have this issue, I am having a Reveneue KPI thats comprised of 3 components(each is a separate measure). I want my bar chart to show the revenue as total in first layer of hierarchy. and want to di...
Need Help
  • sana_sagheer's avatar
    sana_sagheer
    8 years ago

    Thanks everyone, we acheived the solution using Switch function and added component type table as selector for selecting one component type or the other. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Hmm, that's an interesting problem. I am not aware of a way to build a hierarchy with measures so interested in seeing if someone has an interesting solution to this. You could definitely do it in two different visualizations.

  • sana_sagheer's avatar
    sana_sagheer
    Advocate I
    8 years ago

    Thanks everyone, we acheived the solution using Switch function and added component type table as selector for selecting one component type or the other.