Page Filter - Multiple Cards - Multiple Data Sources
Greetings, all!
I would like to build a weekly dashboard for my school district. I would like to report student attendance, staff attendance, discipline, and grade distribution. Unfortunately, these 4 pieces of data come from 4 different sources with 4 different data definitions. I have to do some magic to get common codes for the ID of the particular school.
So I have created a couple of cards (started with student attendance and discipline) and added them to a page called "Weekly Analysis". Each card works fine, and I can turn on the Analyzer and set filters on each of the data sources to only show one school (or a combination of schools). The filters work fine on each card.
But...is there a way to have one filter on the page control the data on both of the cards? So I would change one filter to a particular school and both cards would respect that filter and only show the data for that school
Could you let me know? Thank you so much!!
Comments
-
There should be atleast some common columns on all the datasources to achieve the page lever filter. The one way to do is to add one more column to all the datasource. This can be done by naming "School" as column name on all the datasources that attributes to the name of school . You click on analyzer and set school as the filter. At the bottom of the filter Check the box that says - Apply to all Datasets with School. This should allow one filter to select school and card will display information relevent to that school.
Hope this helps.
0 -
I worked on this while following along here in the KB - http://knowledge.domo.com?cid=pageanalyzer
I've got 5 datasets on a page, and column for "client" is named differently in each. (think along the lines of "Account" vs "Client" vs "Account_Name", etc.)
I put a beast in each dataset to rename the client field in each dataset to be named "*Client". But then when I put a page filter in place, I don't see a message along the lines of "Apply to all DataSets with *Client box" at the bottom of that filter.
Can page filtering on a beast mode not be done? Is the workaround to rename the column in each dataset so it's all the same thing from there?
Thanks,
B0 -
You should put this in the ideas section. I'm sure you're way beyond needing this now but this is a good idea and I think that it would be helpful. If people could 'quick filter' on multiple cards at once it could be very helpful.
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive