I'm trying to implement quit simple calculations, but due to lack of experience have hit the stumbling block with them. The task for me is to calculate count(Event_ID) = today What I've done so far: i tried to use the following syntax: if(floor(Start_Timestamp)=today(),count(Event_ID),0), but it returns 0 everywhere which is not correct, also I tried to use variables on a Load script level, but got the same - 0 everywhere. What I'm missing and what's wrong with my syntax?
Ok, yes that was my fault, I uploaded incorrect data, also I changed the value from today() to today(0).. it' s quite strange that today() can return multiple values based on a number in the brackets.
I was able to figure out how to calculate the max value per year based on a month: sum({<Year={$(=($(vGads)))}, Month={$(=($(vMonth2)))}>} Numval) where vGads and vMonth both are variables.
But how to calculate the max value based on the current month? In this particular case the formula must return 264... I'm out of ideas how to implement this.
