COUNTD of an aggregation in tableau calculatied field

Question

Hi :) I'm trying to do a COUNTD of an aggregation.

COUNTD([CALCULATED FIELD])

the calculated field is an agreggation. I get an error message:

"The argument for COUNTD is alredy an aggregation"

How can i solve this? thanks in advanced.

Ken Flerlage · Accepted Answer

You can't aggregate an aggregate, unfortunately. One option might be to use an LOD for the calculated field. As LODs return non-aggregates, this might work. See # 11 on the following:  20 Uses for Level-of-Detail Calculations

Don Wise · Answer

Basically, it's stating that you've gone as far as you can with the aggregation and you cannot go any farther.  In situations like this, I'd go back to the [Calculated Field] and see if there's some method of counting within it as opposed to trying to aggregate it differently after the fact.     As an alternative, WINDOW_COUNT() might be a workaround.  That will result in a Table Calculation which might require a particular setting in order to work properly and it would generally require the data in the view, remain in the view, otherwise it can collapse down into itself if/when certain data is removed.   Best, Don

COUNTD of an aggregation in tableau calculatied field

Tableau Desktop & Web Authoring

Related Learning

More Help