KPI Calculation Issue

[miguel05]

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

[N1kh1l · Accepted solution]

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