
1. Re: Table Calculation sum of distinct count over time
Shinichiro Murakami Dec 6, 2016 6:32 PM (in response to Philip Perrin)Phillip,
I finally figure out your issue.
You countd iis based on "Date" not month. But duration of period is based on "month", not date.
So, easy way to avoid confusion is change the dimension of month to discrete.
[Numerator 2]
window_max(max({fixed [Order Date]:countd([SubCategory])}),0,11)
[Percent]
[Numerator 2] / attr(([Unique SubCat Each Month FIXED]))
Thanks,
Shin

2. Re: Table Calculation sum of distinct count over time
Philip Perrin Dec 14, 2016 1:48 PM (in response to Shinichiro Murakami)Thanks Shin!!
This was helpful for getting my head wrapped around the problem, but unfortunately didn't produce the desired results. I was able to find a thread that moreorless provided a solution that I needed although I had to make a few adjustments.
The thread I used is here:
Re: Counting "Active Customers" by month
I'm attaching the solution to this thread and will close it out.
I'll be posting a new thread in a moment with more specifics and an anonymized dataset that will hopefully get more at the specifics I'm interested. Thanks again for looking into this!
Phil

3. Re: Table Calculation sum of distinct count over time
Shinichiro Murakami Dec 14, 2016 2:05 PM (in response to Philip Perrin)You are welcome, but if you are OK, could you Mark MY answer as correct?
Thanks
Shin