Unsupported operator: OFFSET

[Sean_Barbara]

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

[Rajasekhar1]

Even iam facing the same issue

[Dawid]

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

[Vanngo93]

@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

[Dawid]

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

[Vanngo93]

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? 

[Dawid]

Are you using Looker Studio?

[Vanngo93]

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.

[Dawid]

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

[Vanngo93]

Understood! Thank you @Dawid