How to compare to the entire dataset, and not just the filtered part of the card?
Hi, so I have a beast mode calculation in one of my datasets that looks like this:
CASE
WHEN SUM(SUM(1)) OVER (PARTITION BY TRACK: Title
,LIBRARY: Name
,TRACK: Version
) > 1 and TRACK: Version
= 'Full Mix' THEN 'YES'
WHEN TRACK: Version
<> 'Full Mix' THEN null
else 'NO' end
The purpose is to make sure that there aren't duplicate track titles. I use this for metadata management, and with thousands of track titles, it's pretty common that people accidentally name their track something that has been used before. We don't want that. What I have right now halfway works, but the problem is that it only compares to other rows if they're in the selected section that's currently showing on the card. However, when working fast I frequently will filter the current album, meaning it isn't comparing to earlier track titles and will always tell me there aren't any duplicates, even if that isn't the case. I could just check before filtering, but it's an extra step that's bothersome, and with the raw amount of data I have, my computer often lags when I try to scroll all the way to the most recent albums to make sure there aren't duplicates.
So my question is, is there a way to do this same function, but make sure that it's calling to every single row of data whether it's part of the filtered section of the card or not? Is there something I can do in the ETL, perhaps? I haven't thought of anything that works. Comparing column to column is easy, but row to row is difficult. Thanks!
Best Answers
-
Hello @ljb18,
You can potentially disable filter interaction on this card, thereby preventing issues where applying a filter may cause your formula not to work.
Change the setting from "Apply to all cards" to "Apply to selected cards."
Deselect the card you don't want the filter to apply to:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0 -
Hi @ljb18,
On the top right corner of the dashboard:
then "Edit Dashboard":
then your filter card should have this "Edit Content" button:
Change Interaction button should be there:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0
Answers
-
Hello @ljb18,
You can potentially disable filter interaction on this card, thereby preventing issues where applying a filter may cause your formula not to work.
Change the setting from "Apply to all cards" to "Apply to selected cards."
Deselect the card you don't want the filter to apply to:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0 -
That seems promising, I'm happy to try it out! Unfortunately I'm not sure where to access the menu you referenced here. Would you be able to explain where I can find that dropdown?
0 -
Hi @ljb18,
On the top right corner of the dashboard:
then "Edit Dashboard":
then your filter card should have this "Edit Content" button:
Change Interaction button should be there:
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 55 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive