5

I'm building a report in GDS and I'm trying to take advantage of the new Chart Calculate Field.

I have the following data

unique_users    120,449
clicks          4,405

I want to calculate the CTR using this formula:

SUM(clicks) / SUM(unique_users)

I keep getting an invalid formula error which I don't understand (attached is a screenshot).

enter image description here

The columns I'm trying to calculate comes from a blended data, this is its definition:

unique_user

enter image description here

clicks

enter image description here

Asaf Nevo
  • 11,338
  • 23
  • 79
  • 154
  • Can you show us the definitions for those? I'm guessing unique_users might be aggreagated already? Count_distinct maybe? – Bobbylank Dec 03 '18 at 09:35
  • I updated my question with the definitions. unique_users is a column from the SpreadSheet the data is being pulled from. its not a calculated field. – Asaf Nevo Dec 03 '18 at 11:06
  • Thanks Asaf, I understand. What does your blended data definition look like? – Bobbylank Dec 03 '18 at 12:52
  • Its connected through US_Time, page_id and URL. I think it has to do with this bug: https://issuetracker.google.com/issues/119319856 – Asaf Nevo Dec 03 '18 at 13:47
  • @AsafNevo I'm currently having the same problem. Did you find a solution? – Tobias Hermann Oct 10 '19 at 15:03
  • @TobiasHerman check the bug report i posted two comments up. It explains the right way of doing this – Asaf Nevo Nov 08 '19 at 15:29

0 Answers0