how date filter card works when there are more than 2 data sets in a dashboard
I have a dashboard with cards built from 2 different datasets A, B. Both datasets have a date column "Event_OccuredAt". Date filter card is from dataset A "Event_OccuredAt".
1. I created a single value card to show how many new users in last month using dataset B based on another date column "User_Created_At" in dataset B. When a date range is selected from Date filter, this card should not change. However, it is changing.
2. I created a pie chart to show user status(active or inactive) using dataset B. The user status is a beast mode. When a date range is selected from Date Filter, seems it always changes to only inactive users. Not fully understand why it works this way.
Can anyone explain what is going on here with the date filter?
Thank you.
Olivia
Best Answer
-
I have two thoughts here.
1. Does the `Event_OccuredAt` field exist in dataset B? Even though it is not being used in a card, if the field exists, then it will filter for those values.
2. When you are editing the dashboard, you can set the interaction to only filter certain cards. Try only allowing the date filter card to impact the intended cards using this option.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
I have two thoughts here.
1. Does the `Event_OccuredAt` field exist in dataset B? Even though it is not being used in a card, if the field exists, then it will filter for those values.
2. When you are editing the dashboard, you can set the interaction to only filter certain cards. Try only allowing the date filter card to impact the intended cards using this option.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Thank you Superman! It works perfect.
Olivia
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive