Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my data source I have multiple columns with the same peoples names in each:
(Column D relates to column C, F to E, I to H)
How do I make a list of the people, so when selecting their name in a filter pane, it counts how many times their name is in each column (like my cut & past image below!):
I'm sure its very straight forward! thank you...
create a link table?
userlink:
load
createdby as user,
creator as type,
case_
residend MyTable;
concatenate(userlink)
load
endineer_by as user,
engineer as type,
case_
residend MyTable;
etc...
count({type={'creator '}>}distinct case_) will then give the number of created cases.
careful : only to be used with the new dimension user