Why is my target value going away when I add filters to my gauge?
I am trying to create a filled gauge to show my sales reps revenue in relation to their goals. I have sucessfully created it, but when I add filters to the card the target line is no longer there. I can't figure out why, I am using a radial gauge in the interim and setting the ranges for their goals, but as they change I will have to go back and manually change them, which I am trying to avoid doing by using the target value field in the first place.
This is the gauge without filters
This is the gauge when I add the filter
Best Answer
-
Okay, so Domo does not recognize filtering on NULL values, which is why your target is not showing. You should write a beastmode and filter on that. Something like ...
case when `Deleted` is null then 'Goal' else `Deleted` end
Then you can filter on 'Goal' and 'No' and your goal target should show. I just tried it and it worked in my instance.
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
Hello Catherin,
Without seeing the structure of your dataset it is hard to tell but my assumption is when you are filtering, you are removing all of the rows where your target value exists leaving you with 0. I just completed a similar test knowing my data is formatted something like this ...
Name Metric Goal
BD 100 90
CS 200 150
AJ 90 70
When I create a gauge I am able to sum the metric and the goal to receive an all in gauge value and target. Then I am able to add filters for each individual name and I still see the value and target of each row.
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Thank you for responding,
I have the metric and the goal set as a sum already, and have not been able to get any filter to allow the target line to stay. I am going to have to figure out another way to do this I think.
0 -
Hi Catherin,
What I was implying is that when you filter it is removing the values of your goal, meaning the actual data of your goal exists in the rows you are filtering out. Is this the case? If you can send a snippet of what your raw data looks like it would help to figure out what the issue is.
Thanks,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Oh, that makes sense actually. This is my data, I had been filtering Deleted is N, so I changed the filter to be blank and N but the target value still disappears. The other filter would be New is True, and that one removes the target as well. I don't get why, but the same thing happens when I put filters on any of the cards that I am using the goal numbers on. So far I have tried, the comparative fill gauge, filled, progress bar, and bullet table.
Sales Rep Date New Retail Total Goal New Goal Deleted Blank Copay Field ACOSTA, CRISTINA 1-Sep-2018 93000 90000 Not Filled ACOSTA, CRISTINA 7-Sep-2018 True 0 Y Not Filled ACOSTA, CRISTINA 19-Sep-2018 True 0 N Not Filled ACOSTA, CRISTINA 17-Sep-2018 True 1160.84 N Filled ACOSTA, CRISTINA 11-Sep-2018 False 90 N Filled ACOSTA, CRISTINA 20-Sep-2018 True 4279 N Filled 0 -
Okay, so Domo does not recognize filtering on NULL values, which is why your target is not showing. You should write a beastmode and filter on that. Something like ...
case when `Deleted` is null then 'Goal' else `Deleted` end
Then you can filter on 'Goal' and 'No' and your goal target should show. I just tried it and it worked in my instance.
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive