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
Even iam facing the same issue
We would need to see some code and how you do it to debug your problem
@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:
Where I put my custom metric:
Under the Metrics areas, click + Add Metrics.
Please help me check on this asap. Thanks very much!
Van
It has to be specific to your data and what you use (Custom dimensions maybe or something else). As the function itself works fine:
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?
Are you using Looker Studio?
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)
This Community is for Looker, not Data Studio, that’s why you may have a hard time getting help with this.
Understood! Thank you @Dawid