
I want to create a table that shows the average, median, and mode of values for each fiscal year. For the median and average, I used the built-in function in tableau but I don't know how to calculate the mode.
Note: the mode should be the most occurred award amount for each FY. For example, if I export the data to an excel file I get the following result
Mode
FY17 $50,000
FY18 $50,000
FY19 $50,000
FY20 $100,000
FY21 $50,000
FY22 $100,000
Please see my workbook attached.
Many thanks,
Amanda
4 answers
Hi @Amanda Mello , will the suggestion below work?
workbook attached for ref. I hope this helps.