Hello,
In a dashboard, I'm wanting a text box to display something associated with the max or top value.
For example if my data was this:
GENDER, JOB_TITLE, EMPLOYEE_COUNT
Male, doctor, 10
Female, doctor, 20
Male, lawyer, 30
Female, lawyer, 40
How could I get it to display "Female - lawyer" given that in this example the max employee_count is 40?
I'm able to do this easily in a chart by setting the value to employee_count and the arguments to gender, job title and then use top N, but I can't use that option since I don't want to display a graph with this, I only want to display the text.
display another value associated with the max value
-
- Posts: 6329
- Joined: Tue Mar 20, 2018 5:34 am
Re: display another value associated with the max value
Hello,
You can use the DataTransformation item to calculate all necessary values and then use it in text components.
Thank you.
You can use the DataTransformation item to calculate all necessary values and then use it in text components.
Thank you.