Hi Everyone,
Can you help me create a weekly line graph in looker studio. I have used google and chat gpt but I’m not successful.
The metric is a CTR from page A to page B.
I have created calculated formulas for this to work but the data does now show. Please help anyway you can.
To witch to weekly granularity, you need to click on the icon at the right of your dimension field.
Then, select ISO Year Week as Data type.
I hope it helps.
Mehdi
@Mehdi_Oudjida it has thanks, however, i actually already knew that one. My main issue is I have created custom calculated fields but once everything is together no data is actually showing. I guess i have missed something somewhere.
What i need to do is show you the fields and what i am trying to achieve to give you a better understanding to help me.
Please, could you share the formula of theCTR, some screenshots of the chart configuration (source type, dimensions, date range config, chart filters…). We will find the problem 
@Mehdi_Oudjida awesome ok, here we go. I am currently using a GSC data source.
Metric - CTR from Page 1 to Page 2
(SUM(CASE WHEN = “https:///cruise/” THEN Clicks ELSE 0 END) /
SUM(CASE WHEN = “https:///search” THEN Impressions ELSE 0 END)) * 100
Dimension
Weekly Data - DATETIME_TRUNC(Date, WEEK)
Filter - Australia only traffic - thats done.
I hope that is enough for you.
@Mehdi_Oudjida are you still able to help?
What data source should i use: GA4 or google search console?
Is it possible to create a formular for what I am asking?
A URL to URL ctr (in GSC ive tried filtering to page path but you cannot) (In GA4 page path is a dimention so it cannot be used as a metric.) What do I do?
Is the answer to create a google sheet and add the data that way so I can create a weekly line graph.
Any help from anybody please!
Anthony
I’m not sure what you want to do dividing clicks for a URL with impressions of another URL but to do it, you need to create a single-table blending with Landing Page as the dimension and Url Clicks and Impressions as metrics.
Then, use the just-corrected formula below for the metric in the chart sourced by the data blending.
(SUM(CASE WHEN Landing Page = “https://cruise/” THEN Url Clicks ELSE 0 END) /
SUM(CASE WHEN Landing Page= “https://search” THEN Impressions ELSE 0 END)) * 100
Don’t take in account the error message and the red color of the metric, the metric will be calculated.
Mehdi
