Conversion Rate - Metric

[ronaldbritos]

Hi everyone,

I’m trying to create a metric block in Corteza to calculate the conversion rate of referrals based on their Status. Here’s the logic I’m aiming for:

pgsql

CopyEdit

Conversion Rate = Admitted / (Admitted + Rejected)

Where:

• Admitted means status = 'Admitted'
• Rejected includes:
  • Denied - Out of Network
  • Denied - No Service Area
  • Denied - No Capacity
  • Lost - Competition

I’ve added two metrics inside the block:

• One with filter status = 'Admitted'
• One with filter for the 4 rejected statuses above

Then, in the Transform value, I tried:

javascript

CopyEdit

(admitted / (admitted + rejected)) * 100

But I keep getting an error like admitted is not defined.

I understand that v refers to the current value, but how can I reference multiple metric values in a transform? Or is this not possible in my version of Corteza?

I’ve attached two screenshots:

• One showing the “admitted” metric config
• One showing the “rejected” metric config and the transform value attempt

---

Goal: Just to have the conversion % shown on a single tile (e.g., “33%”).

If this isn’t possible inside a metric block, is there a recommended way to calculate it via workflow and display it?

Thanks in advance!

[jfortun]

As you said metrics are not indended for that/do not work like that.
I suggest you either use a Funnel chart or a Progress Bar

Progress

Funnel