Filter Based on Another Report
Comments
-
i don't believe that's possible. if both were using the same datasource, you may be able to use page filters to filter all charts on the page.
If it's possible to combine the datasets, instead of using filters, you may want to build drill through charts so instead of filtering for something on the chart, the user can click on it on the chart and drill through to see the same.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Hi there!
It is possible to filter cards on a page on a separate dataset's result set if the column you'd like to fillter on is present in both datasets.
For example:
if I had two cards built on separate datasets that both contained the column "Store", I could apply a page level filter on the store column from either dataset. I would check the box "Apply to all datasets with Store" (on the filter dropdown, see screenshot), and at that point, if the datatype is the same and the value is found in both datasets, both cards will be filtered based on your specified value.
This has to be done at the page level, not at the edit card level.
Let me know if I can provide addtitional clarification.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thanks for the solution provided.
It seems there is a limitation.
I am selecting 'Select All' in the first data set it is not Selecting All columns. I have more than 5000 rows, it is selecting initally 261 when i select All option. I need to search and add to filter manually.
Can you please provide me the solution.
Thanks in Advance.
0 -
Sorry, User01683 I'm not sure exactly what you're referring to.
You mentioned that the "Select All" isn't selecting all the columns, but then you mention that you have over 5000 rows and it only selects 261 when you select the all option.
Few questions:
- Are you talking about the "All" functionality in the page level filter?
- Does your table have 261 unique values in the column you want to filter and you can't select them all?
- Could you take me through step by step and possibly provide screenshots? That way I can address exactly what you're trying to do.
Thanks!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
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.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive