Cannot solve problem: how to FILTER on Subtotals per category
I have data on payments over 2 yr period.
Payments have categories such as grocerries, car, insurance, pharmacy, etc.etc.
I used default domo vizualizer to visualize total costs(Y-axis), BY YEAR (X-axis) using STACKED charts.
when I click within a stack, a specific category lights up - NICE.
Problem: There are over 100 categories, and many are irrelelvant. I just want to visualize top categories where subtaotal WITHIN category is above specific dollar value (e.g. $1,000). IOW, I want to batch exclude all categories of purchases where subtotal/category is less than $1,000.
How do I do that?
In attached pic, these irrelevant categories, are displayed as thin lines.
When I try to filter by value, and set "min" value of $1,000 the app looks for individual transactions, as opposed to AGGREGATE sums within a category.
Comments
-
Is anyone able to help out with this request?
0 -
Hello!
The best way to achieve this functionality is to write a BeastMode that will allow you to filter out data that is less than your desired dollar amount (in your example, $1,000)
CASE
WHEN
column_name >= 1000 THEN 1
ELSE 0
END
Then you will create a filter that filters by 1, removing all of the values that are not at the minimum threshold.
It is important to note that if you are SUMing your column in your card, you will also need to SUM the BeastMode (and vice versa).
e.g.
SUM(`column_name`) >= 1000 ....Then you will create a filter that includes rows where your Beast Mode equals 1, filtering out the 0 values (those with a SUM less than 1000)
Have a great day!
Regards,
Josh Thorn
Technical Advisor
DOMO Support
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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