Class funcion in calculated dimension

[#1]

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!!

[#2 · Accepted solution]

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.

[#3]

Thanks works perfect.

In addition this is also working

=aggr(class(count(distinct Patientnr),1),Datum)      with the expression         count (distinct Datum)