Count Distinct X Over Time

[#1]

I've got a expression I'm struggling with...so pose to the QV experts.

The Bars on the combo below is a simple expression and works fine.

=Count(Distinct Customer)

But want the line to show the unique customer count by week.  But QV is incorrectly summing it up to 117 (Image002), where it should be 37 (Image003).  I've played around with the Aggr() funciton, but unable to crack it.

Help

Jay

[abeyphilip]

Hi Jay,

Seems to be the "full Accumulation" option is enabled on the expression for customer count.

Please check - Expressions -> Accumulation value set for Customer count.

For separate weekly count, you will have to set "No Accumulation"

Regards,

Abey

[MK_QSL]

Try

Aggr(COUNT(Distinct Customer), WeekNumber)

[#4]

Thanks for the quick response – Accumulation is already set to 'No Accumulation'

[abeyphilip]

Hi,

I hope you have checked this setting specifically for the "line graph" expression in question.

Can you please recreate this problem with a sample set of data and post the qvw?

Regards,

Abey