on 05-09-2015 10:28 AM
Hi Experts,
We are facing an issue with count of documents after UNION function, let me elaborate, as we are combining same projections with restrictions, but i have observed that at each projection level we are getting correct count of docs but after union its giving combined result of projections, but i want to see the same count from individual projections as well after the union operation.
Thanks all.
Regards,
Nagendra
Hi,
I think, you can add a dummy column in each project with a different hard-coded value. Say projection_1 will have value as 1 in Dummy_column1, projection_2 will have value as 2 in Dummy_column2. so after union , you will be getting all the records and also aggregator will not cause a problem.
please let me know if I am missing anything
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
UNION implicitly performs a DISTINCT, so identical records are only returned once. If you want to return identical records multiple times, you have to use UNION ALL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nagendra,
Its not the Union , the Aggregation on top of the union will do the trick...
All the Union does is lays over one record over the other
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nagendra,
The aggregation on top of UNION ALL will give you UNION functionality, if all the dimensions are coming from both the sets and different is just measures.
The UNION in calculation view works as UNION ALL. If you want UNION functionality then you can write Calculation View using SQL Script.
If you are looking for a measure which gives you distinct count of your documents, then you can create counter in calculation view.
Regards,
Venkat N.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.