Benchmarking leads against an average
I have a dataset that aggregates all contact us form submissions submitted within my website for all of Australia.
I've got DOMO setup already showing me cards with breakdowns on the number of leads by state, store size, and individual store which are great, but the sales team want more (of course).
I need to be able to show on a card the number of leads for a store and the average for the state or average for the store size (my dataset includes for every lead the store name, store size and state).
I was able to make a beastmode calculation to get the average based on the data that was visible in the card, but when I applied a filter to show a specific store to show the stores leads, my calculation obviously filtered along with it.
Is there a way to have a beastmode calculation ignore the filters or is there a better way of doing what I'm looking for?