cancel
Showing results for 
Search instead for 
Did you mean: 

Mann-Kendall Test

Super User
884 Views
Route217 Member
Member

Re: Mann-Kendall Test

and yes i was referring to Kandell Tau as per your link.

Route217 Member
Member

Re: Mann-Kendall Test

Hi Greg

 

can we use the columns material_ID and FISCAL_MON_START_DT from the PMS complaints table in order to do the Mann Kandell Tau as per your post? 

Route217 Member
Member

Re: Mann-Kendall Test

Stuck on the following measure

 

Tau = 
VAR Mytable = ADDCOLUMNS(VALUES(PMS_COMPLAINT[FISCAL_MON_START_DT]),"CountComplaints", CALCULATE(COUNTROWS(PMS_COMPLAINT)))
VAR __table1 = ADDCOLUMNS(Mytable,"__Concordant",COUNTROWS(FILTER(Mytable,[FISCAL_MON_START_DT]>EARLIER([FISCAL_MON_START_DT])&&[CountComplaints]>EARLIER([CountComplaints]))))
VAR __table2 = ADDCOLUMNS(__table1,"__Discordant",COUNTROWS(FILTER(Mytable,[FISCAL_MON_START_DT]>EARLIER([FISCAL_MON_START_DT])&&[CountComplaints]<EARLIER([CountComplaints]))))

VAR __C = SUMX(__table1,[__Concordant])
VAR __D = SUMX(__table2,[__Discordant])

RETURN

ABS(DIVIDE(__C - __D , __C + __D,0))
Highlighted
Route217 Member
Member

Re: Mann-Kendall Test

Hi Greg

Is there any reason why my Tau value should be (sllightly out) i have followed your worked example to the letter. Its driving me around the bend.