Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
We have data model something like below:
Root | ||||
Month | Year | CID | AID | |
Jan | 2013 | 36 | 124 | |
Jan | 2013 | 36 | 125 | |
Child | ||||
Month | Year | CID | Month Count | |
Jan | 2013 | 36 | 2 | |
Left Join(Root) | ||||
Month | Year | CID | AID | Month Count |
Jan | 2013 | 36 | 124 | 2 |
Jan | 2013 | 36 | 125 | 2 |
Root columns :
Month, Year, CID and AID columns
Child columns
Month, Year, CID and Month Count
LEFT JOIN (ROOT)
Month, Year,CID,AID,MONTH COUNT
When we do left join with the root view we are getting Month Count repeated since (Month,Year,CID) join condition is satisfying.
But in the UI we have only Month, Year and CID as dimensions . In th ui when we try to show SUM(Month Count) it is showing 4 instead of 2.
If i dont perform join and keep qv association then i am getting the correct count ie 2. Is there any way i can keep left join and get the count 2?.
I think it might be better to not join the two tables, thus avoiding the fact duplication first hand.
If you absolutely want to join, you can maybe try something like this as expression in your chart with the given dimensions Month, Year, CID:
=aggr( sum( [Month Count] ), Month, Year, CID, AID)