Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Nevermind - I don't know why but it is fine now....