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?
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board