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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive