CODEWITHSUNDEEP
countdistinctaveragetableau-apitrend
Phil
Phil

Reputation: 73

Is there a way to get the average of a COUNT DISTINCT aggregate in Tableau?

I have a data set that is batch data and connected to Tableau (9.2 Version), therefore, the ticket count is applied as a COUNTD measure in every sheet.. The issue I am having now is I want to get a weekly average (for the previous 31 weeks). Quite unsure of how to approach this. When I change the Measure Value to AVERAGE, it neglects the COUNTD filter. Any help is greatly appreciated. Thank you!

Upvotes: 0

Views: 9374

Answers (2)

Lance Charger
Lance Charger

Reputation: 73

It's an average. Take the Sum or CountD of the value and divide it by the CountD of week[date].

Upvotes: 0

Stephen Berndt
Stephen Berndt

Reputation: 433

I would consider using an LOD to do this.

{FIXED WEEK([date field]) : AVERAGE(COUNTD([measure]))}

This is some more information on Tableau's site about LOD's.

Upvotes: 0

Related Questions