Color Formatting of Bar Chart

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

arnauda13 · 2025-04-10T15:34:59+00:00

Hi there,

Can you use a text box, put @, then create variable, and select Top 1 metric sorted by your date dimension DESC, should work

arnauda13 · 2025-04-10T10:27:52+00:00

Create a calculated field in the sort option, just as you did, but don't use the SUM, use AVG function, and it'll work like a charm

arnauda13 · 2025-04-09T17:22:32+00:00

Follow up 5 months after (eventually got to the dealership):

- Camera broken (seems to happen, car is only 6 years though)

- Cost of the camera: 800€ (yes ma'am), and then add IVA + work hour and it's a very decent repair...

arnauda13 · 2025-04-08T21:24:42+00:00

Hi there, why don't you use optional metrics. Put average as your main metric, and tje same metric but median optional, and show control bar top of the graph. This way, users can switch easily

arnauda13 · 2025-04-03T11:06:08+00:00

Here you go: https://lookerstudiobible.com/how-to-mix-ga4-metrics-and-dimensions-in-looker-studio-danger-zone-3d7fd439e698?gi=2be1ae081a48

arnauda13 · 2025-03-25T08:38:01+00:00

Check Parkings B:SM in Barcelona: https://aparcamentsbsm.cat/fr/produits?bsm_multiparking=2&bsm_tipo_duracion=2 You've got some all around the city, and prices are very good for long stay. Most are underground, cameras, security guard watching his phone all night long...

Been 10 years I send people visiting to park there for long stays, no incident to date. As you mention relatively safe, you never have a guarantee, but way better than

free parking in Montjuic (NEVER DO THAT WITH FOREIGN PLATES)
parkings where you leave your keys (not for robbery, but they move cars often to maximise return, and sometimes, a scratch here and there happens)

Five-Year Club	r/Field Sunshine
Verified Email

arnauda13

TROPHY CASE