I have a performance tab, which displays the # of views a post has received Today, the Last 7 Days and the Last 30 Days in a Chart Element based on a Choice Picker.
Column 1 is Date Viewed.
Column 2, 3 and 4 are each Single Value Columns (Today, 7th Day, 30th Day).
Column 5 is an IF THEN ELSE Column which says: If Date Viewed is on or after TODAY, THEN Today. If Date Viewed is on or after 7 Days, THEN 7 Days. If Date Viewed is on or after 30 Days, THEN 30 Days.
Column 6 is the Choice Picker Column, which is User Specific.
Column 7 is a Single Value Column that uses the Choice Picker Date.
Column 8 is another IF THEN ELSE Column which says if Column 5 = Column 7, then True.
My Chart then shows all TRUE values, which is like 75% accurate.
The issue I am having is that Last 30 days excludes all posts that are also included in Last 7 days and Today because they have their respective Labels.
Ex: Post was viewed 5 times today, 15 times in the Last 7 Days and 40 times in the Last 30 Days.
What it currently displays: 5 views Today, 10 views in Last 7 Days and 25 views in the Last 30 Days.
How would I display:
Last 30 Days = Last 30 Days (25) + Last 7 Days (10) + Today (5) = 40
Last 7 Days = Last 7 Days (10) + Today (5) = 15
Today = Today (5) = 5