I'm trying to create a dashboard metric that shows the percentage of accounts we have business at in Texas.
I have a report that filters only Texas accounts, and then has two groups that break it into business or no business. I also created a formula field for each grouping that divides that row count by the Texas Grand Total row count to get a percentage.
The thing is I'm trying to get the percentage of just the Texas accounts with business on a dashboard metric.
I can only seem to get the row counts to show up in the metric and note either of the summary formula fields. Is there any other clever ways to get the percentage of just one of the groups on a metric?