1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Disable Auto Aggregation

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Is it possible to disable auto aggregation on a calculated field?

 

Im having the following problem with my data aggregation:

 

I have two fields that need to be multiplied by each other, to get a third calculated field.

To aggregate the third field I want to add all the values in the third field.

Data studio sets the aggregation of the third field to "Auto", and I can not change this.

 

The problem is that Data Studio adds all the values in the first field, then adds all the values in the second field, and then multiplies them to "auto" aggregate the third field.

 

eg:

What happens:

10 x 2 = 20

20 x 4 = 80

-------------------

30 x 6 = 180

 

 

What I need to happen:

10 x 2 = 20

20 x 4 = 80

-------------------

20 + 80 = 100 (sum of the above answers)

 

 

Disable Auto Aggregation

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

It's not the third fields aggregation that you need to change, it's the aggregation for the two fields you're multiplying.

 

If these are GA metrics, you're not able to change the aggregation method.

What data source are you using?

Re: Disable Auto Aggregation

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Im pulling a simplified version of the data through Google Sheets.
The first field aggregation is correct.

However there is no logical aggregation of the second field. If I set the second field to "None" then it seems to give me the Minimum value of the third field.

 

Disable Auto Aggregation

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆

I noticed the same behavior in Grand Totals when summering.  Tried NONE,AVG,MIN,MAX but nothing helped. I am not sure why its applying the calculation on the summary row. if its the Grand Total, it should simply sum up the values in the column. Could this be a bug?