Count All Days in Selection Regardless of non-Date Selections

[matthewjbryant]

I want to be able to select a WC (Work Centre) and see how much quantity was produce in a date range, but I also want to know how many days that WC could have been active. The sort of thing I want to see is this, but it is hard coded on the attached QVW.

I suspect the solution is either Aggr or a cleaver Set Analysis, but I'm, at a loss.

[maxgro · Accepted solution]

maybe

count(TOTAL DISTINCT Date)

[matthewjbryant]

Are you kidding me? It's THAT easy?! That TOTAL qualifier is very nice!

[maxgro]

Yes, very nice

What does the TOTAL qualifier do?