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?
