Drill Down fails after adding filter to main card
I have a simple table table card, source is an ETL, summarized by Customer. The drill down is a different data source, customer daily sales activity which I turn into a line chart: X = Date, Y = amount. In this scenario, the drill down works fine. The problem starts when I add a filter to the main card, specifically numerical, i.e. Total Sales >= $500.00. Once I add the filter, the drill down won't return anything. No error messages, but no data.
Anyone ever seen this?
Best Answer
-
I agree with @AS Aaron here. You will need to have a total sales column in your drill down data set. If you don't already have it, you can create it with the windowed function in the ETL (or with a MySQL Redshift data flow).
Let us know if you need help creating the field. Or if this isn't the issue, we will have to go back to the drawing board.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
Can you tell us if the sales column exists in the second dataset and if it has the same name as the first data set? That's the first place I'd look.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I agree with @AS Aaron here. You will need to have a total sales column in your drill down data set. If you don't already have it, you can create it with the windowed function in the ETL (or with a MySQL Redshift data flow).
Let us know if you need help creating the field. Or if this isn't the issue, we will have to go back to the drawing board.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive