live data versa compared historic using average counts

[qliklizzy]

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

[Brett_Bleess]

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

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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

Regards,
Brett