count based on other columns

[dineshkumar]

Hi All,

I'm having two tables

Instance:

if i count complaint no based on login as a dimension and filter as sand and oil,, the output will be

Actual output:

scenario:

but i want oil_filter, sand_fliter to display count(complaint_no) based on assigned_login for login dimension.

expected output:

For Your reference attached is the same file.

Thanks,

Dinesh.

[adamdavi3s]

That seems correct to me based on the explanation  given?

[dineshkumar]

to be practical inline_1 is live table, unique row data gets entered here at live , inline_2 is history table.

when complaint gets created it will be at inline_1 and from then whenevere a case is picked for processing, reverification these data goes to inline_2...

IF , login 1 creates complaint a, the row entered in inline_1, then later when it goes for complaint resolution say login guy 2 picks the case and process it ..

e.g. in inline_1 user is  login , later when login picking case is assigned_login in inline_2.

so, login 2 picked the case, hence oil_filter 's count should show in login2  and not who created the record...