topic % Calculation in App Development

% Calculation

ha1 — Tue, 14 Sep 2021 15:32:50 GMT

Hi Everyone,

I have to calculate Approved rated based on 2 fields.

1. ActualDate, 2. Approved date.

Data:

AppID	ActualDate	ApprovedDate	Status	Cnt
1	9/10/2021	9/10/2021	Aprvd	1
2	9/10/2021	9/11/2021	Aprvd	1
3	9/10/2021	9/10/2021	Declnd	1
6	9/10/2021	9/10/2021	Declnd	1
4	9/11/2021	9/11/2021	Aprvd	1

Expected result:

ActualDate	Rate	Formula(Just for understanding)
9/10/2021	25%	(=1/4)….. only 1 application is approved on 10th out of 4 total applications, one application is approved on 11th so I haven't considered for 10th
9/11/2021	200%	(=2/1)….. 2 applications are approved on 11th over total applications(1), one application is created on 10th but approved on 11th

"ActualDate" field is dimension.

Actual Approval Rate: Sum({<Status = {'Aprvd'}>}cnt)/sum(Cnt)

but in my requirement Approved count need to consider when ActualDate = ApprovedDate

Re: % Calculation

sunny_talwar — Tue, 14 Sep 2021 15:49:05 GMT

The best way to handle this would be to create a Canonical Date in your script

Re: % Calculation

ha1 — Tue, 14 Sep 2021 16:25:29 GMT

looks interesting but creating multiple data sets is highly impossible here as data set huge with multiple dimensions, is there any other suggestions.

Re: % Calculation

ha1 — Wed, 15 Sep 2021 06:08:46 GMT

Any Suggestions please?

Re: % Calculation

sunny_talwar — Thu, 23 Sep 2021 13:16:01 GMT

Were you able to resolve it or is this still pending?