Broken line chart and want to connect the dots
Hi - I have this beast mode that I am using in a bar line chart. However since there aren't values for each time interval the line is showing as dots. How do I get the line to connect?
Here is the beast mode and I can't seem to get things connected without breaking syntax:
CASE
WHEN 'id'
='LIABILITY' THEN SUM('value'
)
END
Best Answer
-
Not to disagree with the estimable GrantSmith, but the problem is not that you're missing data at the gaps of your graph, it's that you do have data at those gaps, and it is NULL. A line/bar can plot a continuous line with different missing date values, as long as there aren't NULLs at rows:
Your BeastMode currently produces a NULL for every row that is not "LIABILITY", which is what is causing the gaps.
What is the goal of the BeastMode? Is it to graph "LIABILITY" against "NOT LIABILITY". If so, you could just create a categorical variable for your series, and use that as your series.
Or if it's to graph LIABILITY against everything, you could prepare your data in an ETL. Filter your LIABILITY rows and append them as duplicates to your dataset, and again graph using a categorical variable as your series (Liability duplicates vs. Not liability duplicates).
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
If your data doesn't have data then it won't connect. You'll need to insert records in your dataset to have a contiguous line in your chart
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
That's unfortunately not possible
0 -
Not to disagree with the estimable GrantSmith, but the problem is not that you're missing data at the gaps of your graph, it's that you do have data at those gaps, and it is NULL. A line/bar can plot a continuous line with different missing date values, as long as there aren't NULLs at rows:
Your BeastMode currently produces a NULL for every row that is not "LIABILITY", which is what is causing the gaps.
What is the goal of the BeastMode? Is it to graph "LIABILITY" against "NOT LIABILITY". If so, you could just create a categorical variable for your series, and use that as your series.
Or if it's to graph LIABILITY against everything, you could prepare your data in an ETL. Filter your LIABILITY rows and append them as duplicates to your dataset, and again graph using a categorical variable as your series (Liability duplicates vs. Not liability duplicates).
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive