Displaying a Blank chart
Hi,
Is there a way to have a Chart display blank data until filtered. For example I have two charts one with products x,y,z and then the other being a blank chart. When I click on product X, I want the blank chart to display every customer. When no product is selected I want the chart to be blank. Hopefully that makes sense.
Best Answers
-
Depending on your data, you could a beast mode that's like
case when count(product) = 1 then 'Show' else 'Hide' end
and then filter the card to "show" and it should only show data when 1 product is selected.
1 -
@trafalger 's solution is really elegant. I was scratching my head trying to incorporate a variable. Probably want a COUNT(DISTINCT product), though, assuming you have more than one customer row per product. Also, note, this will only work with selecting exactly one product. If you want to be able to select more than one, you might want to create a range of possible selections (exclusive of the total number of products, otherwise it won't be blank by default)
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
Depending on your data, you could a beast mode that's like
case when count(product) = 1 then 'Show' else 'Hide' end
and then filter the card to "show" and it should only show data when 1 product is selected.
1 -
@trafalger 's solution is really elegant. I was scratching my head trying to incorporate a variable. Probably want a COUNT(DISTINCT product), though, assuming you have more than one customer row per product. Also, note, this will only work with selecting exactly one product. If you want to be able to select more than one, you might want to create a range of possible selections (exclusive of the total number of products, otherwise it won't be blank by default)
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
Great Solution. We need it to only show one product at a time so this works amazingly. Thank you!
0 -
Ah good callout, I would use DISTINCT there.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 560 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 575 Beast Mode
- 13 App Studio
- 28 Variables
- 582 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 26 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 356 Distribute
- 95 Domo Everywhere
- 259 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive