How to fix a target line independent of filter selection?
![user084060](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
Hi, I build a card that shows monthly sales volume (bars) and shows the average sales volume per consultant as a line (=target). Now, I added filters at the top, that allow to select for a specific consultant. I would like to fix the average sales volume, such that when selecting a specific consultant a direct comparison of that consultant's monthly sales volume to the average sales volume. Please advice.
Comments
-
There is a beta feature in development called Filter Groups that will bring you the functionality you're describing.
In the immediate term, to support having a 'group average' while allowing filtering down to an individual you have to get clever with how you structure your data.
You can
- add group average as a column per individuals salesperson (I don't recommend, but it is the simplest to understand and least flexible after implemented).
- APPEND a copy of the entire dataset and fill "salesperson" with "default" then in filter cards always include 'default' and the selected salesperson. All metrics must be built with an appropriate CASE statement.
- to avoid having to remember to include 'group average' in filters, and only select one salesperson:
create a duplicate of the data for EACH salesperson, then label each duplicated section as one salesperson group. use cases where the salesperson group = salesperson to identify when it's the numerator versus part of the denominator.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.6K Product Ideas
- 1.6K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 286 Workbench
- 4 Cloud Amplifier
- 6 Federated
- 2.7K Transform
- 91 SQL DataFlows
- 581 Datasets
- 2.1K Magic ETL
- 3.5K Visualize
- 2.4K Charting
- 626 Beast Mode
- 29 App Studio
- 33 Variables
- 616 Automate
- 157 Apps
- 423 APIs & Domo Developer
- 34 Workflows
- 2 DomoAI
- 31 Predict
- 12 Jupyter Workspaces
- 19 R & Python Tiles
- 373 Distribute
- 104 Domo Everywhere
- 266 Scheduled Reports
- 3 Software Integrations
- 101 Manage
- 98 Governance & Security
- 4 Domo University
- 15 Product Releases
- Community Forums
- 38 Getting Started
- 29 Community Member Introductions
- 91 Community Announcements
- 4.8K Archive