This content has been marked as final. Show 5 replies
I have a table loaded which contains these fields on top of others (omitted):
autonumber("A"&"B"&C&"D") as %ItemID,
I have a table created with dimensions of Month and rating. The measure is Count(distinct [%ItemID]).
The total does not compute correctly, as shown below. It should be 59 and not 60 by adding up the 3 ratings. Any ideas on what could be the cause of the discrepancy? Thank you.