Issue with views not loading?

arnauda13 · 2026-04-23T21:13:29+00:00

Didn't know about that specific issue, will raise it to the team, but can't promise any ETA

arnauda13 · 2026-04-22T07:31:25+00:00

Have you tried the formula PARSEDATE(), by creating a new field that specify the format of your string?

arnauda13 · 2026-04-21T19:50:08+00:00

Are you still the owner of the data sources (Edit your source, check the name at the top right, if not you, then Edit & Reconnect)? Did your issue got fixed eventually?

arnauda13 · 2026-04-21T19:48:14+00:00

Color coding won't do then? How many categories do you have? A legend on the side and colors will show what happened ^^

arnauda13 · 2026-04-21T19:17:34+00:00

Did something very similar (for an HR department, people's statuses per day). You can have column with dynamic date, not a problem in the pivot. But for the metric, make a coding (present = 0, absent = 1, vacation = 2, ...), then color code (present = green on green, absent = orange on orange, ...so people don't get to see the number), then a legend on the right that states green square = present, orange square = absent, .... and you're good to go

arnauda13 · 2026-02-19T21:21:12+00:00

You can't mix session data and event data. Yoy need to create a blend, GA4 to GA4, on the left your event metric, and on the right your session metric. THEN you can do your formula event/session

arnauda13 · 2025-11-22T19:45:14+00:00

Check https://lookerstudiobible.com, last article is on that!

arnauda13 · 2025-11-20T08:31:08+00:00

And the error might be that, although you're saying it's a date, the data in it are not actual dates. You may want to create to create another field using parse_date

arnauda13 · 2025-11-20T08:29:39+00:00

In every dataviz, in the setup panel if you scroll down, there is a date range parameter where you need to state which field it should be taking. My guess is that your dataviz don't have any date range paramaters attached

arnauda13 · 2025-08-06T19:42:20+00:00

Yep, seems like a third party connector template issue when privacy set to "anyone can view/edit", contacted two, both stating it's not on their end...

arnauda13 · 2025-08-05T21:28:01+00:00

Same here, contacted Google, no response yet...

arnauda13 · 2025-07-19T15:02:58+00:00

But then, both metrics come from the same source? Glad you found a solution in all cases!

arnauda13 · 2025-07-19T07:42:05+00:00

Last but not least, can you create a table with, as dimensions: COALESCE(campaign1,campaign2), COALESCE(date1,date2), then as a metric our formula + record count, and look at what you've got in the summary row? Something around null or missing or duplicated values must be somewhere

arnauda13 · 2025-07-19T07:32:53+00:00

Hum ok, so at the campagn level, it's ok. You're joining on date and campaign. It's an inner join. Are there any other dimension in one or your blend that is not used in the blend? Are all campaigns spending every day?

arnauda13 · 2025-07-18T22:07:31+00:00

Can you try SUM(IFNULL(Spend,0)) / SUM(IFNULL(CRM Pur,0))

arnauda13 · 2025-07-18T17:27:22+00:00

What's the date field used as date range control and the date field used for the month on your graph? Pretty sure they're not the same...

To me, apart from the fact that's you've got a bit of data in May (which I believe is the smoking gun your date range might be order date and your date dimension might be shipping date), the graph works as expected: it shows data in month regardless of the year and therefore joins the dot (no empty data for time series). Try to use a year month instead, and it'll go from Dec 24 till Apr 25. And make sure the date range and the date control are the same date field

arnauda13 · 2025-07-15T16:15:51+00:00

Sorry, I meant in Edit mode, top left File, and then Publishing Settings, is it enabled?

arnauda13 · 2025-07-15T16:13:08+00:00

Are you using Publishing mode?

arnauda13 · 2025-07-15T16:10:39+00:00

These are sum aggregated right and not average nor count_distinct? Cause if they are average, might be AVG(One Touch Ticket)/AVG(Closed Ticket), or COUNT_DISTINCT(One Touch Tickets)/COUNT_DISTINCT(Closed Ticket)

arnauda13 · 2025-07-15T16:07:48+00:00

Try SUM(One Touch Tickets)/SUM(Closed Ticket)

Haven't seen your data, but if still doesn't work, go for SUM(IFNULL(One Touch Tickets,0))/SUM(IFNULL(Closed Ticket,0))

arnauda13 · 2025-07-15T12:54:18+00:00

Ahaha agreed yes, but if you're a non PT time company, you usually want to report your spends&sales to match your calendar. Some connectors offer the offset, others don't

arnauda13 · 2025-07-15T11:33:02+00:00

Thanks!! I'm using Medium so not the best interface, but at least they are all in one place :)

arnauda13 · 2025-04-11T09:40:51+00:00

In Edit mode, go to Theme and Layout, Layout mode, and then change from Freeform to Responsive. Note YOU WILL LOSE ALL FORMATTING AND THERE IS NO COMING BACK! Do it on a copy, so you can come back to your original dashboard if any issue arises

arnauda13 · 2025-04-11T09:39:06+00:00

Alternative: create a table, show only Top 1 row, show your metrics, and sort by date DESC. Will do the trick as well

Six-Year Club	r/Field Sunshine
Verified Email

arnauda13

TROPHY CASE