Aggregate Count While Still Filtering By Time

I want to make a pie chart out of the following rows where a row value is based off the count (not just 1). The rows are grouped by time. The table looks like the one below. The problem is the chart doesn't aggregate Success to 12 but leaves them as separate series Success 5 and Success 7 in the legend. I have multiple status conditions so how would I aggregate them while still being able to filter by time? I tried the Bucketing data page, but couldn't get it to work properly.
Time | Count | Status
12:00 | 5 | Success
8:00 | 7 | Success
12:00 | 5 | Fail
8:00 | 7 | Fail
12:00 | 5 | None
8:00 | 7 | None
Comments
-
I have taken some time and found the solution so here it is for anyone wondering.
SUM(CASE
WHEN Status = 'Success' THEN `Count
`WHEN Status = 'Fail' THEN `
Count
`WHEN Status = 'None' THEN `
Count
`
…
END)3
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 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