live data versa compared historic using average counts

qliklizzy — Sat, 16 Nov 2024 19:58:17 GMT

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

Re: live data versa compared historic using average counts

Brett_Bleess — Wed, 09 Oct 2019 20:35:38 GMT

The only two ways of which I can think to go at this are something like the following Design Blog post:

or set analysis:

This will kick things back up as well, not sure if someone else may have better ideas or not...

Regards,
Brett