Trying to build a query where i need to count the values using two characteristics (Survey, Tag) and a keyfigure (Counter, which is always 1)
This is sample data in the Cube
Survey TAG Counter
-
--- -
1 F1 1
1 F2 1
1 K1 1
1 # 1
2 F1 1
2 # 1
2 F1 1
3 # 1
4 K4 1
4 F1 1
4 # 1
Let me explain the data. there can be multiple records for a Survey with different TAG values. TAG value can be sometimes 'not assigned #'. For every row, counter 1. Survey '3' does not have any tags except the 'not assigned'.
I need these measures in the query.
1. Total number of Surveys (answer 4)
2. Total number of Survey without any tags (answer 1, only Survey 3 has no tags)
anyway how this can be built in the query designer.
As always 10 points guaranteed for the solution.
Thanks
Gova