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

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    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.

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    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.

Answers

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    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.

  • ljb18
    ljb18 Member

    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?

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    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.