topic Re: Percentage Calculation in Visualization and Usability

Percentage Calculation

sat_tok52 — Wed, 22 Dec 2021 16:59:54 GMT

Hi All,

I have to show percentage based on the visiteddate , I have a column visit-date, so i have to show visited Account Id percentage like suppose out 10 Acount Id's how many id's are visited that percentage and who are not visited that percentage .Below table Null symbol means not visited id's.

Suppose 7 id's are visited Count(VisitDate)/Count(Distinct AcctID) i.e's 7/10=70%

Suppose 3 id's are Not visited NullCount(VisitDate)/Count(Distinct AcctID) i.e's 3/10=30%

Data:

AcctID	VisitDate
1	10/1/2019
2	10/2/2019
3	10/3/2019
4	-
5	10/5/2019
6	10/6/2019
7	10/7/2019
8	-
9	10/7/2019
10	-

Expected Result:

AcctID	VisitDate	Expected Result
1	10/1/2019	70%
2	10/2/2019	70%
3	10/3/2019	70%
4	-	30%
5	10/5/2019	70%
6	10/6/2019	70%
7	10/7/2019	70%
8	-	30%
9	10/7/2019	70%
10	-	30%

Thanks.

Re: Percentage Calculation

sunny_talwar — Wed, 23 Oct 2019 11:31:50 GMT

May be this

Count(DISTINCT TOTAL {<AcctID = {"=Len(Trim(VisitDate)) > 0"}>} AcctID) / Count(DISTINCT TOTAL AcctID)

and

Count(DISTINCT TOTAL {<AcctID = {"=Len(Trim(VisitDate)) = 0"}>} AcctID) / Count(DISTINCT TOTAL AcctID)

Re: Percentage Calculation

sat_tok52 — Thu, 24 Oct 2019 12:15:50 GMT

Hi Sunny,

Thanks for your quick reply.It's working like what i am expecting.

Thanks.