Forum Discussion
Button to filter dates based on another field/slicer
Super UserAnonymous , expected output is not clear,
refer if these two examples can help?
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
I might be able to make that work (I only see one example, was there supposed to be another?), but I'm not sure. It looks like it is relative based on today's date, which isn't what I want.
Lemme see if I can make this clearer: if someone chooses the May video from the slicer, with a release date of May 1, I should see the views data from each of the next seven days.
Release Date: May 1, 2021
Views Data:
May 1, 2021: 100
May 2, 2021: 150
May 3, 2021: 130
May 4, 2021: 75
May 5, 2021: 50
May 6, 2021: 45
May 7, 2021: 30
So the BAN at the top would say 580 views and the line chart would have these seven days, etc. If I chose the 3 day button/slicer, the BAN would say 380 views and the line chart would have three days.
If they then choose the August video, with a release date of Aug 1, I should see views data from Aug 1-7.
I could do the 3, 7, and 14 days as a slicer instead of buttons, but I cannot do a straight date range slicer - it must filter based on the video title slicer to get into the right start date for the chosen video.