I am trying to calculate a mode (most commonly filled quantity) within my data set and have read through a few articles on how to do it, but am getting stumped. Here is what I currently have:
So with the very simple example above, my mode for Supply1 would be 5 and for Supply2 would be 3.
What is the calculation to achieve this?
Thanks in advance.
One example by nested LOD
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...