5 Replies Latest reply: Nov 20, 2017 3:33 AM by Mei Zheng Tay RSS

    Bar chart value label

    Mei Zheng Tay

      Hi,

       

      I have a table loaded which contains these fields on top of others (omitted):

       

           autonumber("A"&"B"&C&"D") as %ItemID,

           rating

       

      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.

      screencap.PNG