formula

[Anonymous]

Hello everyone

i want to show the percent of patients that their (send document date) -(discharge date) are greater than 21 to all patients

something  like this:

if((A-B) >21 , Vsum=Vsum+1)

c=Vsum/totalpatients

i would appreciate if anyone can help me to write this formula

[swuehl]

Maybe something like

=Count(DISTINCT If( [SendDocumentDate] - [DischargeDate] >21, VisitID)) / Count(DISTINCT VisitID)

or in a chart context to ignore dimensions, use an additional TOTAL qualifier:

=Count(DISTINCT If( [SendDocumentDate] - [DischargeDate] >21, VisitID)) / Count(DISTINCT TOTAL VisitID)

[Kushal_Chawda · Accepted solution]

Create the Flag in script like below

LOAD *,

          if([SendDocumentDate] - [DischargeDate] >21,1,0) as Flag_Days

.....

FROM Table;

Now use below expression

=count(DISTINCT {<Flag_Days={1}>} PatientID) / Count( distinct total PatientID)

[Anonymous]

Thanks to reply

it should be correct but unfortunately didn't work.

Thanks anyway

[Anonymous]

Many Thanks Kushal