KPI Calculation Issue

miguel05 — Mon, 22 Aug 2022 17:50:17 GMT

Hello Guys!

I am new on SAC and currently I am struggling to work with the calculations on SAC, more specifically, to calculate a KPI from my dataset.

Each row of my dataset is a transaction of a sale, where I have a column with the information of the payments that were, Received, Authorized, and Denied.

I want to know the percentage of transactions that were Authorized versus the ones that were Received, like the following:

Number of Transactions = Received / Number of Transactions = Authorized

Is there any way to perform this type of calculations on SAC? I've been searching a way to do it, but wasn't successful yet so if any of you could help me on this, I would be much appreciated

Kind Regards,

Miguel

Re: KPI Calculation Issue

N1kh1l — Mon, 22 Aug 2022 18:19:30 GMT

miguel05

You need to create Restricted measure for each Payment types Received, Authorized, and Denied.

Like below.

In Measure select your Sales transaction measure. In Dimension select Payment Type and in value select Accepted. Repeat this for other two Authorized and Denied. Then create the KPI calculated measure with formula Number of Transactions = Received / Number of Transactions = Authorized

Nikhil

Question Re: KPI Calculation Issue in Technology Q&A

KPI Calculation Issue

Re: KPI Calculation Issue