5 Replies Latest reply on Mar 20, 2012 4:54 PM by Alex Kerin

Aggregation Problem

allysonwinters2 Mar 19, 2012 12:13 PM

Hi everyone,

I need to sum the first part of this calculation in order to get the correct percentage:

([Claim count <60 days])/[Claim Count]

This my calculation for Claim count <60 days:

(if ([DaysToLastDPDocket ])<=60 then 1 else 0 end)

If I try to put a "sum" in front of the claim count <60 days, I get my favourite aggregation error.

Any help would be appreciated.

Allyson

1. Re: Aggregation Problem

Alex Kerin Mar 19, 2012 3:09 PM (in response to allysonwinters2)

What is [Claim Count]?
Like Show 0 Likes(0)

Actions
2. Re: Aggregation Problem

allysonwinters2 Mar 20, 2012 6:24 AM (in response to Alex Kerin)

It is the number of claims that meet a criteria.
Like Show 0 Likes(0)

Actions
3. Re: Aggregation Problem

Alex Kerin Mar 20, 2012 6:56 AM (in response to allysonwinters2)

Is it possible for you to post a tbwx with mocked up data if sensitive?
Like Show 0 Likes(0)

Actions
4. Re: Aggregation Problem

allysonwinters2 Mar 20, 2012 1:00 PM (in response to Alex Kerin)

Hi Alex

That would be difficult. Our data set is made up of multiple tables with multiple calcs. I don't think I could do a mock up that would capture our dataset.
Like Show 0 Likes(0)

Actions
5. Re: Aggregation Problem

Alex Kerin Mar 20, 2012 4:54 PM (in response to allysonwinters2)

Okay, how about full descriptions of each of the calcs (and the calcs that they use), plus a screenshot of the error?

That could do it.
Like Show 0 Likes(0)

Actions

Tableau Community Forums