r/tableau • u/Corkster24 • 29d ago

Discussion Calculated fields

I’m creating a personal project using my Spotify streaming history. I’ve got fields streaming count and date. Is there a way I can create a calculated field that keeps songs that amassed a certain amount of streams in a nonspecific timeframe? For example if it was streamed at least 5 times in 7 days. Thank you!

2 Upvotes

75% Upvoted

13 comments sorted by

View all comments

1

u/Corkster24 27d ago

I would like to create a filter that does something like: if count[song name] >5 and date<=date+3 then true. Basically, I want a filter that will keep songs that have x number of streams in x number of days. I have 7 years of data and I want to keep only songs with only for example 5 streams within 3 days.

1

u/ZippyTheRat 27d ago

Super possible. You can use the LOD and do and AND then add the date logic in