Dashboard Chart Display for Amounts and %
We created a dashboard that includes a chart from a sheet summary report. However, while the total records are correct, the % is not (i.e., the 1st Meeting total is 67, but it shows 47%, which is not accurate - it's actually 12% of the total). So, I created another summary field to calculate the correct %, which works, but then the dashboard shows 12% and 47%). Would someone please explain why this appears this way? And, if there's something we could do to correct this? Thank you!
Screenshot #1 - Using %
Screenshot #2 - Using Amount (as a %)