Calculated field with filter data table

[Mohamed_Necib]

Hello,

I have two data with peronalized filter and I want to divide nb_de_candidats / nb_de_session.

I did not find a way to do that efficientle.

IO tried calculation filed but can’t make it work.

Do you have any idea ??

Thank you for your help.

[Looker_Studio_B]

Bonjour Mohamed,

You will need to blend data as I see you have filters on your KPIs, so, top of your page, Resource, Manage blended data, and add blend, then:

• Left table: put sessions as a metric, adding your Filter “Session hote candidater” at the bottom, date auto
• Right table: put event count as a metric, adding your Filter “filtre Event name” at the bottom, date auto again
• If there are no more dimensions (apart from the date that is automatic), you can cross join (at the top between the two tables). Don’t put any other dimension, only one metric on the right, one metric on the left. If you want to filter by dimension, you’ll need to put both on dimensions and do a left join, inner join or full outer join depending on your data and needs
• And then, using the blended data, you can writhe the following formula SUM(event count)/SUM(sessions)

Should work (the problem you’re facing is to apply 2 different type of filters (sessions & events) on the same calculate field, GA4 doesn’t like it that much…