Filtering Across 2 datasets with slightly different field names

Hello - I have a group of cards on a page built on 2 datasets. I want to filter them using a selector card that contains the customer's name. On one dataset the field is named "name_full" and the other is "customer_name_full". This is done purposefully and I do not want to make them identical if possible. Can you link those two fields together for filtering purposes without adding more fields to the datasets?
Best Answer
-
You can create a variable that won't clutter up your dataset but you'd have to explicitly list each customer name in the variable and regularly update the variable as customer names are added, deleted, or modified.
0
Answers
-
You don't have to add a new field to the dataset via the etl, but you'll need to add a new beastmode to the dataset at the card level.
On a card where the column is called "customer_name_full", create a beastmode called "name_full" and in the editor section of the beastmode double click the "customer_name_full" column. Click the box to share it on the dataset. This should allow you to use one filter card based on the "name_full" column.
0 -
So no way to do it without sharing beast modes to the dataset? Those really clutter things up.
0 -
You can create a variable that won't clutter up your dataset but you'd have to explicitly list each customer name in the variable and regularly update the variable as customer names are added, deleted, or modified.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 643 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 771 Beast Mode
- 74 App Studio
- 43 Variables
- 721 Automate
- 185 Apps
- 463 APIs & Domo Developer
- 59 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive