Showing Totals and % of Totals on Same Table in Explore
I'm currently trying to build out an interactive dashboard for our Finance dept that shows the following:
- # of Tickets by Category
- % of Total tickets that each Category makes up
I've build out the report (see Image #1); however, I'm struggling with having a TOTAL that is in integers and a % OF TOTAL in percentages show on the same query (see Image #2 for desired result).
Any help you can provide would be GREATLY appreciated!!
Katie
-
Hey Katie,
It looks like you resolved this yourself, but if you're still running into questions please respond on the ticket you have open with us.
That said, if you're willing to share how you resolved this in a comment on this post, it might help future Explore users with this same issue! -
I would love to know how this was resolved. I'm currently having this issue too :(
-
Abby
There is an example here.
The way to do it is create a new custom metric that is just a copy of the COUNT(Tickets)
Then use result manipulation to display the percentage of the total.
Please sign in to leave a comment.
3 Comments