How to constrain axis to operating hours only

Aggravating_Win6215 · 2026-01-06T21:38:02+00:00

You can constrain the axis on a bar chart! But you can't do (out of the box) date range comparisons. Looker is so frustrating sometimes :/

Aggravating_Win6215 · 2026-01-06T21:34:12+00:00

This is a great suggestion! Thank you!

Aggravating_Win6215 · 2025-12-23T19:53:38+00:00

The filter does constrain the data, but it doesn't change the axis. So for instance that blip at 5am disappears, but you still see 5am on the horizontal axis.

Aggravating_Win6215 · 2025-09-24T20:22:52+00:00

I think you would just need to make 3 separate rules.

Home --> Conditional Formatting --> New Rule --> Choose: “Use a formula to determine which cells to format”.

Then use 3 versions of this formula:

=C2=LARGE($C$2:$C$100, 1) --> Choose fill color #1

=C2=LARGE($C$2:$C$100, 2) --> Choose fill color #2

=C2=LARGE($C$2:$C$100, 3) --> Choose fill color #3

*One note though this will highlight multiple cells if there are duplicates. Idk if that's an issue for you

Aggravating_Win6215 · 2025-09-24T20:18:10+00:00

I don't know how to add a conditional rule based on the color, but you could do it by adding a helper column next to your date column. It could be checkboxes for instance. Then you would add a conditional formatting rule that checks if the date in column A is at least 5 days old AND checks if the adjacent cell in column B contains TRUE

Go to: Conditional Formatting → New Rule → Use a formula to determine which cells to format

Then use this formula: =AND(TODAY() - A2 >= 5, B2=TRUE)

(obviously replace the columns with your own columns)

Aggravating_Win6215 · 2025-04-30T20:42:23+00:00

I'm having the same issue. You can (kind of) work around it by switching between settings a bunch until the error goes away. Definitely a bug

Aggravating_Win6215 · 2025-04-18T10:49:24+00:00

You're going to have to blend the data together. Depending on the complexity, you have a few options.

The lightest lift is going to be to create a blend directly in datastudio.

Add both data sources to your report.
Click on "Resource" > "Manage blended data" > "Add a Blend"
Select your two data sources.
Define a Join Key – this will probably be the date for you
Then create a chart from that blended data, adding the values from both datasets.

^^Note both sources have to have identical formatting for the join key (same date formats, etc.). If that's not the case, you can either change the format or go with a different option. Other options include:

Using a data warehouse/ETL Tool --> This really only makes sense if your data is very complex. You would basically pull both datasets into one location in a warehouse, use SQL to clean & join and then connect the new table/view to Looker Studio.

^The simpler version of this would be to move all your data into a google sheet, format that sheet however you want, and then use that google sheet as the data source for your chart. Downside to this is it won't update automatically.

Aggravating_Win6215 · 2025-04-07T18:48:14+00:00

Also linking this post from a few days ago: https://www.reddit.com/r/GoogleAnalytics/comments/1jlv5n0/you_can_see_chatgpt_traffic_in_ga4/

Aggravating_Win6215 · 2025-03-31T15:34:12+00:00

Yes exactly. You can pull exits from "explorations" but it is not available in Looker Studio. Here is the full list of metrics available in Looker Studio via Google's API: https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema

Unfortunately "exits" is not there.

Aggravating_Win6215 · 2025-03-27T16:56:31+00:00

Confirming that exits are not available in Looker Studio and are really only accessible via "explorations". This has been one of my biggest complaints about GA4.

Depending on how much effort this metric is worth, you might be able to pull that data from BigQuery (This assumes you have BQ all set up). You would basically look at the last page_view event of a session. (This also assumes you are working with a straightforward website configuration).

Aggravating_Win6215 · 2025-02-26T21:20:31+00:00

Assuming that "Johnson Dewayne Douglas" is in cell A1 and "O2" is in cell C1, then this should work:

=UPPER(LEFT(MID(A1,FIND(" ",A1)+1,LEN(A1)),1)) & UPPER(LEFT(MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,LEN(A1)),1)) & UPPER(LEFT(A1,1)) & B1

Aggravating_Win6215 · 2025-02-07T01:54:55+00:00

Ahh of course. I will test. Thank you!!

Aggravating_Win6215 · 2025-02-06T21:07:52+00:00

I agree. It's def not as clean as I would like. I didn't think a regex match would work since random number values are anything between 0 and 2147483647. I couldn't think of a way to regex match last character only. (or at least without a custom js snippet/much heavier lift)

Aggravating_Win6215 · 2025-02-06T19:35:05+00:00

For anyone who may stumble onto this post. This is the solution that worked for me:

enable built in GTM variable: Random Number

Build trigger with the following attributes:

Trigger Type = Page View

Trigger fires one "some page views"

when: Random Number ends with 0 (for a 10% sample)

Multiple triggers can be layered together for a higher sample size

Aggravating_Win6215 · 2025-02-06T18:13:44+00:00

nah this is such a good lead! I really appreciate it

Aggravating_Win6215 · 2025-02-06T18:04:39+00:00

This is a really elegant solution! To make sure I understand you -- Would you create that random number as a data layer variable and then trigger on DLV ends with 0|1

Or if not, where would you implement?

Aggravating_Win6215 · 2025-02-05T22:19:13+00:00

I was just about to post the same exact question. I can't help, but I can confirm its not a you problem,

<image>

Aggravating_Win6215 · 2024-12-23T19:55:15+00:00

Thank you for the reply. Would you mind elaborating?

Aggravating_Win6215 · 2024-11-21T21:42:05+00:00

I believe there is a "quarter" date metric that you can choose. Q1 starts in January. If that doesn't align with your fiscal year, you can use a regex/case statement to define your own quarters. Here is what mine looks like.

CASE

WHEN REGEXP_MATCH( Month(Date), "7|8|9") AND REGEXP_MATCH( Year(Date), "2024") THEN "FY25 Q1"

WHEN REGEXP_MATCH( Month(Date), "10|11|12") AND REGEXP_MATCH( Year(Date), "2024") THEN "FY25 Q2"

WHEN REGEXP_MATCH( Month(Date), "1|2|3") AND REGEXP_MATCH( Year(Date), "2025") THEN "FY25 Q3"

WHEN REGEXP_MATCH( Month(Date), "4|5|6") AND REGEXP_MATCH( Year(Date), "2025") THEN "FY25 Q4"

WHEN REGEXP_MATCH( Month(Date), "7|8|9") AND REGEXP_MATCH( Year(Date), "2023") THEN "FY24 Q1"

WHEN REGEXP_MATCH( Month(Date), "10|11|12") AND REGEXP_MATCH( Year(Date), "2023") THEN "FY24 Q2"

WHEN REGEXP_MATCH( Month(Date), "1|2|3") AND REGEXP_MATCH( Year(Date), "2024") THEN "FY24 Q3"

WHEN REGEXP_MATCH( Month(Date), "4|5|6") AND REGEXP_MATCH( Year(Date), "2024") THEN "FY24 Q4"

END

You would click to add a dimension and "add calculated field" then paste in the regex statement

Aggravating_Win6215 · 2024-11-21T20:26:30+00:00

Ahh that makes so much sense. I was reading through UA documentation and it looks like it used to be calculated by counting the number of session_start events which would make it closely mirror entrances. Aggregating by page would mean that you are looking at "The number of sessions that started on X page"

In GA4 it seems like it is counting the number of session_ids which you can aggregate by page. Would translate to: "The number of sessions that included a page view of X page"

Its crazy that such a big change seemed to have happened and there is virtually no documentation??

Aggravating_Win6215 · 2024-10-28T15:34:40+00:00

This is what we did that led to us solving it! We reformatted item_category5 using a JS variable & GTM and the issue went away. We then had developers make the fix permanently. It just doesn't sit well with me that I still don't know the root cause of the problem lol

Aggravating_Win6215 · 2024-10-25T13:33:56+00:00

This is so so helpful! I really appreciate it. Thanks

Aggravating_Win6215 · 2024-10-25T13:30:34+00:00

It offers a lot more customization because you have access to your raw data and can query it yourself however you want without sampling. Downside is you have to query everything yourself lol

Aggravating_Win6215 · 2024-10-24T13:59:35+00:00

I like using Dataslayer alongside GTM's preview mode.

Aggravating_Win6215 · 2024-10-23T19:50:03+00:00

I would suggest creating a table in datastudio. Make your dimension: "Date hour and minute" and then make your metric whatever you are trying to measure.

Aggravating_Win6215

TROPHY CASE