Thank you for your response but ultimately i will not be using a table card. I will be using a single value gauge card. And for the result I would be looking for a result of 50. So Line #1 shows up 3 times with a value of 5 but I only want one instance of the 5 to be included in my sum. Same goes for each of the other line…

This worked. Thank you for the explanation. Good to know that the beast mode will stop calculating at any part of the formula once it does not find that data in the time frame of the data set. I assumed that the formula in total would never equal zero so I dropped the "else 0" off. I now know that is not the case. Thanks…

This other beast mode works when I type in the exact date I am looking for but obviously I do not want to change that each week. sum(case when `date` = `4/20/19` then `greater than 70 days` else 0 end) If i do this below then I get an error message: sum(case when `date` = max(`date`) then `greater than 70 days` else 0 end)…