display another value associated with the max value
Posted: Thu Jul 27, 2023 6:42 pm
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.
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.