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.
Is anyone able to help out with this request?0
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)
column_name >= 1000 THEN 1
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).
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!
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 80 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive