Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a live feed every ten mins which gives me counts of patients admitted so far, and I have this split various ways.
But I have another feed which consists of the 4 weeks worth of admissions, and the previous years same period to be used for comparison etc.
so I want to basically have a count so far today - which I have
then a count (average) for the last 4 previous Wednesdays ( if Wednesday is today)
and a count of last years' 4 previous Wednesdays etc.
I was just going to put theses in text objects as number comparisons, and then again into pivots, so show more detail /drill
how am I best going about this -I cant even get an average count 😞
my today so far on dataset 1 = =Count(UnitNumber)
I have this by hour also: with a dimension = hour(admissionDate)
Thanks !
liz
The only two ways of which I can think to go at this are something like the following Design Blog post:
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
or set analysis:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
This will kick things back up as well, not sure if someone else may have better ideas or not...
Regards,
Brett