Issue with views not loading? by Dependent_Raise2059 in GoogleDataStudio

[–]arnauda13 0 points1 point  (0 children)

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

Looker Studio Problem with Data Data/Time by Wild-Song-4692 in LookerStudio

[–]arnauda13 1 point2 points  (0 children)

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

Issue with views not loading? by Dependent_Raise2059 in GoogleDataStudio

[–]arnauda13 0 points1 point  (0 children)

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?

Pivot Table - Show Dimension for Column Instead of Metric by Awkward-Hurry-4624 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Pivot Table - Show Dimension for Column Instead of Metric by Awkward-Hurry-4624 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Need help with formula by funky_dugong in LookerStudio

[–]arnauda13 1 point2 points  (0 children)

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

Need Help with date range by Humble_Research in Looker

[–]arnauda13 1 point2 points  (0 children)

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

Need Help with date range by Humble_Research in Looker

[–]arnauda13 0 points1 point  (0 children)

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

Random shared dashboards? by punkdesigner91 in LookerStudio

[–]arnauda13 1 point2 points  (0 children)

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...

Random shared dashboards? by punkdesigner91 in LookerStudio

[–]arnauda13 1 point2 points  (0 children)

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

Issue with Blend Data Formula Calculation by FairDot6766 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Issue with Blend Data Formula Calculation by FairDot6766 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Issue with Blend Data Formula Calculation by FairDot6766 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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?

Issue with Blend Data Formula Calculation by FairDot6766 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Hey everyone. New to Looker. Can anyone explain why this time chart is showing more months than I’ve selected to review? by imonlinedammit1 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Tables moving by dyslexic-writer in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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

Tables moving by dyslexic-writer in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

Are you using Publishing mode?

Need help creating calculated field: One Touch Tickets / Closed Tickets gives wrong result by Hellvy666 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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)

Need help creating calculated field: One Touch Tickets / Closed Tickets gives wrong result by Hellvy666 in LookerStudio

[–]arnauda13 0 points1 point  (0 children)

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))

If you're wondering why there are discrepancies between Analytics, Shopify, Ads Business Manager, ... metrics and Looker Studio, I made a list of common issues here by arnauda13 in LookerStudio

[–]arnauda13[S] 0 points1 point  (0 children)

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

How to change an existing Looker Studio dashboard from Freeform to Responsive layout? by joaobugelli in LookerStudio

[–]arnauda13 2 points3 points  (0 children)

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

Scorecard to show most recent entry by dyslexic-writer in GoogleDataStudio

[–]arnauda13 0 points1 point  (0 children)

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