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
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive