user18178

Comments

  • 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…
    in Sum Column Based on Distinct values in another column Comment by user18178 November 2019
  • 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…
    in Beast Mode not calculating for Current Year to Date Comment by user18178 May 2019
  • 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)…
    in Case statement using date field Comment by user18178 April 2019
Default Avatar