1 Reply Latest reply: Aug 16, 2012 5:48 PM by Rebecca Molstad RSS

    Troubleshooting Table

    Rebecca Molstad

      Hi All,

       

      I have a bar graph that uses the following expression:

       

      =Count(DISTINCT TicketNumber)

       

      This expression is showing the correct values. However, I also have a straight table below my bar graph that should show every record. In many instances it is showing too few records.

       

      For example the count distinct function equals 7 tickets for a certain user, but the straight table only shows 4 tickets (The Excel source shows 7 and none are duplicates). Does anyone have any ideas?