Hi,
I'm building a dashboard where I want to look at the geagraphical spread of the audience, seperated into four groups (The city of Malmö, the region Skåne, Sweden and outside of Sweden). For each group I would like both the number of tickets and the share of the total ticket count (for example that 32 % of the total ticket count is bought by people living in Malmö). The problem is that I use widget filters to get the ticket count for Malmö, so then I don't know how to get the share of the total ticket count? For now I have manually divided the ticket count with the number of tickets, but this only works for a static dashboard and that is not what I want.
Grateful for any help,
Sofia
Hi Sofia,You will want to look into filtered values instead of filtering the widget. Your ticket count formula would look like SUM(Ticket Count, Geo Area). You can right-click on the Geo Area part and then filter right there to the area you're looking for. You would do the same for the share of total ticket count SUM(Ticket Count, Geo Area)/(Total Ticket Count).
Hi Madeline,
Great, thank you so much! It worked perfectly
Br,