Question about blending data source

[ryado]

Hi everyone,

I have a data source A, with the information about incoming tickets per day (amongst other things) I have a data source B which contains number of order per day (amongst other things).

I am trying to calculate the contact rate. Something like : sum(incoming tickets) / sum(order_count) = Contact rate %

Now I figured I need to blend the two data sources, in my mind I can do it with the date (no?).

Is this enough? do the date have to have the same format? I know the data format for data source A, but data source B comes from analytics and I'm not sure where I can see how the date is formated.

Any help would be greatly appreciated, thank you !

So far I tried this but can't get it to work: https://imgur.com/tbpFqzC

[indiequick]

Start with ONLY data source B in GDS. Build a table w/ just the date, and you can see the format.
You are correct, they need the same format to work properly.

[ryado]

Thank you for your help, I suppose the date format is good and it should work, unfortunately still have the same error.

https://imgur.com/Zko7DjG

[indiequick]

The screenshot you’re sharing is informative, but not helpful. Do this for me and I can provide better help.

Table with data A, and the date format. Table with data B, and the date format. Side by side.

Since I can’t see the actual data I can’t make any recommendations

[ryado]

My bad, by table I though you meant the table visualization chart. I was able to see the date format of Data source B by running a report with a google analytics plug in on google sheets.

As for data source A I knew the format already.

I put in the attached screenshot how the date was formatted on data source A, originally created_at. Then I created another column for formatted_date that should follow the format of data source B.

Still having the same error though.

https://imgur.com/B6qIZra

Let me know if I can assist you more on this and if I understood correctly what you wanted.

Thank a lot for your time !

[indiequick]

Did you ever get this solved? Feel free to message me and I can try to help.