Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am working on a study project to build a management dashboard for a school project.
I am far ahead of my classmates, because i find this very interesting to work on.
I am having some issues I can't solve myself. I have searched for common questions and i see them asked frequently but non of the solutions seem to solve my 'problem'.
I have a very small dataset to work with.
I have a table that looks like this:
Name | Frequency
A 34
B 21
C 19
D
.
.
I need to show in a single text field what the most occuring Name is, in this case 'Name A'.
How do I manage to do so?
I am very sory for my noob-isch question on this case, unfortunatly I cant figure out how to do this.
Best regards
Joerie
Student Business Intelligence
Create a Text Object and write below
=FirstSortedValue(Name, -Frequency)
Update : If Frequency is coming as an aggregation of some field... i.e. Count(Name) you can use as below...
=FirstSortedValue(Name, Aggr(-Count(Name),Name))
Create a Text Object and write below
=FirstSortedValue(Name, -Frequency)
Update : If Frequency is coming as an aggregation of some field... i.e. Count(Name) you can use as below...
=FirstSortedValue(Name, Aggr(-Count(Name),Name))
Thanks!
That simple!
Please close the thread by selecting appropriate answer.