Data Label Text is Dissapearing

#1

Hi All,


I am looking to create data labels that give counts of cases based on ranges of a certain variable. For instance, I'd like one data label to have the count of people between the ages of 0-20 and another for anyone over the age of 20. When I try to add these through the filter in the data analysis panel the text within the label disappears entirely. I can filter by a categorical variable very easily but when I try to work with a continuous variable (such as age) the number within the data label completely dissapears. Any suggestions?


Thanks in advance!

#2

Data Labels are used to display a single measure or hierarchy value. When trying to display more than one measure, it might return null or the first element in the list. If your metric set is set to not display null values, the data label may seem to disappear.


In order to display the count for a continuous variable you can create formula measure. For example, I have a cube with age and name as shown below:

Image title


Now at the dashboard level, I have created a formula measure that will display the SUM of count measure, as shown below:

Image title

Image title

Now you can filter the measure, for example for the ages 0 to 20, re-visualize it as a data label, and then go to Properties -> Text and set it to display the sum measure:Image title

The final result looks as follows:


Image title