How to make % frequency chart in dashboard (reasons for QC failure)
I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency.
The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure.
"In Dashboard" shows the output that I want in my dashboard. A simple T-chart with mode of failure and % frequency
Thank you for your help!!! I really need this answered within the next two days
Help Article Resources
Check out the Formula Handbook template!