Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to calculate yesterdays attendances against today so far.
today so far in my live feed is just count(unitnumber)
but for yesterday I can pull the date through and it counts all of yesterday; but if its 10am I need the count up until then. I have another field called RunTime - how do I combine them into the below?
if(AdmDate=today()-1 , AdmDate) = yesterdays date
Thanks
Liz
I've done it! bit of endless googling before and after posting on here never quite finding the answer but played with it and got the correct output! - thanks for you help
=count(distinct(if(
AdmDate=today()-1 and AdmissionDateMonth < RunDateTime-1, UnitNumberMonth)))
if(AdmDate=today()-1 and Runtime=num(hour(now())) , AdmDate)
makesure runtime has number value from 0 to 24, else adjust accordingly either on right or left
hello again,
no it didn't work what do you mean 0-24?
the run date time is 03/10/2019 09:50:00
thanks
hi
I changed it to this
=if(AdmDate=today()-1 and hour(RunDateTime)=num(hour(now())) , AdmDate)
and it return yesterdays total still - is this because its in the dimension, should it go elsewhere
because the hour now does = hour yesterday, so my sum needs to only sum from midnight to 11 but its not.
thanks
Hi
I managed to solve it
=if(AdmDate=today()-1
and AdmissionDateMonth<RunDateTime-1
, AdmDate)
but this doesn't work In a text object box - do you know why?
I've done it! bit of endless googling before and after posting on here never quite finding the answer but played with it and got the correct output! - thanks for you help
=count(distinct(if(
AdmDate=today()-1 and AdmissionDateMonth < RunDateTime-1, UnitNumberMonth)))