Simple formula not working in google data studio connector?

1
votes

I'm working on a data studio connector, and trying to do a very simple formula. I simply want divide a field by 100.

  {
    id: "ctr",
    dataType: "NUMBER",
    semantics: { conceptType: "METRIC", semanticType: "NUMBER" },
    formula: "$ctr / 100",
    name: "ctr",
    label: "Ctr"
  }

Google data studio gives an error when using it. "Sorry, we encountered an error and were unable to complete your request."

If I remove the formula line, all works fine. What is up here?

I know I can reference another field with $myfieldid though I want to reference the current field, in this case ‘ctr’. It also helps me avoid extra fields in my schema I’m just using for calculation.

Anyone one run into a similar issue? Is this possible?

1
google-data-studio

1 Answers

1
votes

You are defining the field with id 'ctr' and using it's value inside the same block.

You should create a new field to use '$ctr' value and then perform your calculation over it.

At this time i don't think there's a way to reference itself on the filed definition.

What you could do is set that field as "isHidden": true so it doesn't appear for the user and you only use it as a parameter on another field.