Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
shirleyc40
Creator
Creator

Weekly count is different from individual day count

Hi, I'm having this weird issue again where I do a distinct count for measure and a drill down of dates for dimensions, but the weekly count is different from the count added separately by date. 

shirleyc40_0-1596728224236.png

I don't have a pic for the individual dates, but I added them twice separately after selecting W32, and got 86 (which is correct). 

The measure formula I use is Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber)

My data is formatted so that there could be repeating event numbers with the same status and dates. Like I could have two entries with the same eventnumber, status, and date

 

Labels (1)
3 Replies
jwjackso
Specialist III
Specialist III

Is it possible that the EventNumber can span multiple days?  If it does and you count distinct, the EventNumber that spans multiple days would only be counted once.

shirleyc40
Creator
Creator
Author

Yes, they can spread over different days. How can I count both?

asinha1991
Creator III
Creator III

maybe try this

sum(aggr(Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber),yourdayfield))