Extra 0 bar in bar chart with beast mode
I have (using Beast mode )created 11categories in vertical bar graph card ,
but in the it shows up with extra '0" bar
How can i delete this extra 0 bar?
Answers
-
This is because your beast mode is returning NULL for some records (where none of the conditions are met). You can filter out the NULLs and it will remove it from the chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith , Thanks for the help.
0 -
For data like this :
The vertical bar chart required is : each bar giving count of column categories , tried with calculated fields but cannot get desired answer
0 -
Hi @rupinderkaur87,
First, you have to Unpivot in ETL. Then It should work with a simple COUNT. Here is the same table:
Dynamic Unpivot in ETL:
Result table:
Bar chart:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1 -
Hi @Manasi_Panov , the suggested solution worked for this problem, thanks you so much.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 611 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 717 Beast Mode
- 52 App Studio
- 40 Variables
- 671 Automate
- 171 Apps
- 448 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 118 Manage
- 115 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive