use expression as a dimension

[#1]

Hi all,

I would need to use the results of an expression as a dimension:

example:

(if(dimension='data',1,0))

This give me a list of all emloyees with a dimension field specified as data and how many times the instance is per employee.

Employee     count

ID405           33

ID302           1

ID010           22

now I would need to group:

Data Count     No of Employees

1                         20

22                         55

and so forth..

Help please

[#2]

Hi Markus,

Try this..

load  dataCount ,

        count(Employee) as [No of Employess]

resident table

group by datacount ;

hope this helps

Regards,

Koti

[#3 · Accepted solution]

Hello Markus,

Please see the attached QVW for the solution.