I have data from three sources: Facebook Ads, Shopify, and Google Ads. I created a blended data source using the date column as the common dimension (Facebook.Date, Shopify.Date, and GoogleAds.Day) to build a table.

I am trying to establish conversion rate for a page with the general equation button clicks/views. Since a filter reading “Event Name = “button_click” would filter out views, I found that I need to create a metric specific to the event type. I found the following formula which seems to partially work for what I need:

I am trying to build a report in Looker, where one column happens to have text content in markdown file format. For example consider a ‘student’ table with below contents:

I have one set of data and it is structured like this in two separate columns.

So I have two columns that I need to add up and divide. The problem is that each one requires a different date range dimension to sum and have the proper outcome so the final division turns out correct.

I have 3 charts on my dashboard from 3 different GA4 accounts I want my drop down filter to work on all of then, I am unsure how to set this up.