Hello,
Was hoping someone could help me display this data correctly. I'm able to get the correct counts but I can't get my list to display right.
Below is a mock up of data.
Instrument UserName ticket id
drums john 758654
drums john 758655
bass guitar john 548933
acoustic guitar john 123456
guitar john 123456
guitar john 123457
guitar john 123458
I'm using the formula - count(distinct [ticket id] for [User Name],[Instrument])
But this displays my list as below.
User Name count
john 1
2
3
total 7
The correct count is 7 but I would expect 7 to be listed as a detail line. Is there just a setting in the query that I need to set? I'm using cognos analytics 11.0.12.
Any help is greatly appreciated. Thanks
Just changed the detail aggregation to total and now its working. Never mind!
Hopefully this can help someone else