Y axis disappears for a grouped and stacked bar with line chart
Hello,
I have a grouped,stacked bar chart with Line. On the X-axis, i have 5 columns grouped and stacked along with a line date wise . Issue is when i have nulls in all 5 column for a particular date and i filter to see the card only for this date, only the date appears , y axis is not visible any more. Is there a Way to over come this, i cannot ignore the Nulls or make it 0( business rule).
Regards,
Rohil
Comments
-
Domo can be a little ... weird when dealing with NULLS as filters.
Try wrapping your DATE column in a CASE statement and replacing the NULLS with an extreme value that allows you to identify them.
ex.
CASE WHEN <dateColumn> is null then '2030-01-01' else <dateColumn> end
To prevent yourself from having to maintain the beast mode you could set the value to a date based off of today's date (example set it to current_date() or end of month) or set it to 1990-0-01 ... whichever is most appropriate.
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 -
Hello,
In my case the date(x axis) value is not null; but the Y-axis(say sales) is null.
The below screen shot is of the card.
Screen shot of Card when Data is present.
0 -
Sorry, if your values are NULL but you cannot set them to zero, what is the desired result? What do you want to see?
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 -
I need to see both the Axis(x axis to show the date seected) but no data for Y axis(at least i need to see the scale) . Is that possible?
0 -
What do you want to see in your chart?
If you leave the value at NULL then you don't show anything because by definition there is nothing to show.
If you set the value to 0 then you have a value in your legend.
You could create a separate table card that maps NULL activity to a column 'No Recorded Activity' but it would be difficult to embed that in your chart.
I strongly recommend you set aside business rules for a moment and define what you want your user experience to look like and articulate the information that they are supposed to extract from your chart, then proceed from there.
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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive