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

    Bar chart value label

    Mei Zheng Tay



      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.