Unsupported operator: OFFSET

Looker Q&A Looker
1

Hello,

I try to calculate the variation of a metric that change everyday, I would like to display the percentage of change one day to another day to day.
I saw that I need to use the offset() function but I don’t understand why I can not use it and it returns the error: Unsupported operator: OFFSET

Can you help me with this? I can’t find any help about this error.

Thanks a lot

1 Like
2

Even iam facing the same issue

3

We would need to see some code and how you do it to debug your problem

4

@Dawid I faced the same issue. What I did exactly is shown in this guide :https://cloud.google.com/looker/docs/best-practices/how-to-calculate-percent-change-percent-previous

${ Internal Promotion Views} /offset(${ Internal Promotion Views}, -1) - 1

The errors are:

  • $ is illegal to input
  • Offset is not supported function

Where I put my custom metric:

Under the Metrics areas, click + Add Metrics.

Please help me check on this asap. Thanks very much!

Van

5

It has to be specific to your data and what you use (Custom dimensions maybe or something else). As the function itself works fine:

1 Like
6

Hi,

Thanks again for your very quick response. I do not know why my Looker is not the same look as yours. Here is mine. There is no Expression, just Formula. Doesn’t it the issue as I created my custom metrics on the wrong workplace?

7

Are you using Looker Studio?

8

yes! what I am using https://lookerstudio.google.com/reporting/. I cannot find out the ‘Table Calculation’ as the guide.

I can only do as I explained above (and in the screenshot)

  • Where I put my custom metric:
  • Under the Metrics areas, click + Add Metrics.
9

This Community is for Looker, not Data Studio, that’s why you may have a hard time getting help with this.

1 Like
10

Understood! Thank you @Dawid