Skip to main content

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
0/9000