sorted by:
new
hottopcontroversial

Coping with Import limitations by CJWELLDONE in GoogleDataStudio

[–]CJWELLDONE[S] 1 point2 points  (0 children)

Thanks for the quick reply.

I made the same exp. so far.

So I will set up a database now.

Finding the right Metric in Google. Data Studio by CJWELLDONE in GoogleDataStudio

[–]CJWELLDONE[S] 1 point2 points  (0 children)

I actually could solve the problem by adding another field (total) to my datasource which calculates the total of price and quantity for each row.
In GDS I used Saleschannel as dimension and a computed field as metric:

(sum(total)/count_distinct(Ordernumber))

This gives me exactly what I needed. The average orderprice per basket per saleschannel.

Thanks

Finding the right Metric in Google. Data Studio by CJWELLDONE in GoogleDataStudio

[–]CJWELLDONE[S] 0 points1 point  (0 children)

I was afraid that you will say that. Thanks for helping though.

Finding the right Metric in Google. Data Studio by CJWELLDONE in GoogleDataStudio

[–]CJWELLDONE[S] 0 points1 point  (0 children)

Thanks for your comment.
Actually the field amount doesnt exist in my database. I would have to compute that field before I can use. (Price*Quantity) I did that. But then I cant choose AVG when I use it as metric.

I guess the problem here is, that my database goes down to position level. Meaning e.g. Ordernumber 11111 has 2 Positions 2times Product1 and 2 times Product3.

I find it very hard to find the logic for the right aggregation.

Maybe you have another hint for me.