How to compare two firstsortedvalue and get count, percent

[SrideviAyyala]

Hi All,

I am new to Qlik Sense. I'm currently working on a chart which represents the comparision between the current & previous scores.

I got the Current & Previous Score values using FirstSortedValue function &  and commented them accordingly

Current Score = FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date)

Previous Score = FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date,2)

Comment = If(FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date) > FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date,2), 'Better',
If(FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date) < FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date,2), 'Worse',
IF(FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date) = FirstSortedValue([Likelihood to Recommend Score], -Customer_Response_Date,2), 'Same')))

Now I'm trying to calculate the below.

1. Get the Percentage of  Current Score > Previous Score(Better%), Current Score < Previous Score(Worse%) and Current Score = Previous Score(Same%).

Below is the Example Data:

Comment	Customer Response Date	Current LTR Score	Previous LTR Score
Worse	11/12/2019	5	8
Worse	09/12/2019	6	8
Worse	03/12/2019	7	8
Worse	18/12/2019	7	8
Worse	25/11/2019	8	9
Worse	14/08/2019	7	8
Same	21/05/2019	7	7
Same	04/10/2019	10	10
Same	02/10/2019	9	9
Same	21/11/2019	7	7
Same	06/08/2019	1	1
Same	05/12/2019	8	8
Same	07/05/2019	9	9
Same	13/08/2019	9	9
Same	09/08/2019	8	8
Same	18/12/2019	8	8
Same	03/12/2019	9	9
Same	03/09/2019	10	10
Same	08/11/2019	8	8
Better	01/10/2019	9	8
Better	11/12/2019	8	7
Better	11/12/2019	7	6
Better	05/12/2019	7	6
Better	19/08/2019	8	6
Better	20/08/2019	9	5
Better	06/08/2019	8	6

Could anyone help me with the calculation.

Appreciate your help.