Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table which has dimensions week day and date. I have an expression "Count(DISTINCT([Grower No.]))", which counts the distinct number of growers in the least.
How do I tweak this expression so that it shows distinct number of growers per date? At the moment it has the same value for each date which is the distinct number of growers in the whole subset.
Thank you
Herbiec
Hi
The problem most probably lies in your data model, where the date is not properly associated with the table containing Grower No. I suggest that you upload a sample of your model (click 'Use advanced editor' at the top left of the reply entry screen). or at least provide a lot more information about your model.
HTH
Jonathan
Count(DISTINCT(Aggr([Grower No.],myDate)))
Hi
The problem most probably lies in your data model, where the date is not properly associated with the table containing Grower No. I suggest that you upload a sample of your model (click 'Use advanced editor' at the top left of the reply entry screen). or at least provide a lot more information about your model.
HTH
Jonathan
If you use weekday as dim1 and date as dim2, your expression should give you what you want.
Spot on Jonathan,
My associations were a bit of, once I had them realigned, it worked perfectly.
Much appreciated.
H