Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am looking for a solution to solve this.
should work with the class function but no idea how to.
Any idea (see attached example)
total beds needed x times occured
3 1x
4 1x
5 1x
many thanks in advance!!
Hi Mavan,
I think you should do it in the script first:
Left Join
LOAD
count(DISTINCT Patientnr) as CountNum
Resident a
Group by Datum;
wnd then the dimmension will be:
=class(CountNum, 1, 'X')
See the attached,
Hope it help.
Hi Mavan,
I think you should do it in the script first:
Left Join
LOAD
count(DISTINCT Patientnr) as CountNum
Resident a
Group by Datum;
wnd then the dimmension will be:
=class(CountNum, 1, 'X')
See the attached,
Hope it help.
Thanks works perfect.
In addition this is also working
=aggr(class(count(distinct Patientnr),1),Datum) with the expression count (distinct Datum)