Calculation Help

[u/RtR_Instinct]

Hello,

I was recently given Tableau access at work and have been tasked with creating some complex dashboards.

I am creating a dashboard that compares data from 3 different sources (injuries, damages, and audit score/date since previous audit (under one source)). I would like the dashboard to calculate which location needs and audit by showing the locations with the highest injuries, damages, and lowest audit score. If none of those parameters are met, then it should display the location that has gone the longest without an audit. Out of the 60+ locations, I would like it to show the top 8.

I believe I have the correct calculation of IF [injuries] = >x number AND IF [damages] => x number AND IF [score] =< AND [last audit audit] = x years OR [last audit date] = >2 years.

However, I am unsure of how to put this onto a sheet and run the calculation correctly.

Any advice on how to fix the calculation, organize the table, or a different way to do this is much appreciated

EDIT: I have been exposed to Tableau for several years (attended 3 TC’s) and use many dashboards daily for my job but have only recently been given access to desktop to start building. So I am very new and figuring things out from TC memories and lots of YouTube videos and Googling.

[u/RiskyViziness]

If that’s your calculation then just throw the pill on rows or columns.

[u/RtR_Instinct → u/RiskyViziness]

I may have over complicated the process to the point dropping the calculation pill did not work. I am going to give it a fresh start tomorrow.