Like many companies, we have a multilevel geographic hierarchies e.g. Division-Region-Area. We have dashboards with indicators across the top showing summary information based on the user's selection. Other widgets allow users to select / drill into lower organizational levels, and when they do, the Indicators change to reflect the newly-selected level.
What we need is the ability to in a label, next to the Indicators, something that reinforces what the Indicators are showing. Example: If Division 1 is selected, it should show "Division 1." If the user selects Region 3 in Division 1, the label should show "Region 3."
I think this could be handled if Sisense enabled the creation of a calculated (formula) Dimensional value with literals e.g. IF(COUNT(Area) = 1, Area, IF(COUNT(Region) = 1, Region, IF(COUNT(Division) = 1 , Division, 'Company'))).
Can anyone help us? Thank you.
Please sign in to leave a comment.