Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I am trying parrallel coordinates plot. I am getting error at node_percent.
dual(
$(=concat('if($Field='&chr(39)&$Field&chr(39)&',concat(distinct ['&$Field&']))','&'))&'
'&num( 100*node_percent, '#,##0.#', '.' , ',' )&'%'
,
$(=concat('if(textcount(total ['&$Field&'])=0,if($Field='&chr(39)&$Field&chr(39)&',0.1+((min(['&$Field&'])-min(total ['&$Field&']))/(max(total ['&$Field&'])-min(total ['&$Field&']))),0),if($Field='&chr(39)&$Field&chr(39)&',0.1+((aggr(nodistinct rank(['&$Field&'],4),['&$Field&'])-1)/rangemax( (count(distinct total ['&$Field&'])-1) ,1 )),0))','+'))
)
Please help me where i am going wrong.
Thanks
Pavan
check with filed name node_percent or variable you have created ?
Vikas