Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please help me with idea
I have line chart.
Dimension:MYear
Expression: Label-> Master avg([qID_1_Overall Experience])
Text color:
If((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2)>30,
If(([Master]-Above([Master]))<0 and (1-TDIST(fabs(([Master]-Above([Master]))/SQRT(((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience])))/
(count([qID_1_Overall Experience])*Above(count([qID_1_Overall Experience]))))*(sqr(Stdev([qID_1_Overall Experience]))*(count([qID_1_Overall Experience])-1)+
Above(sqr(Stdev([qID_1_Overall Experience])))*(Above(count([qID_1_Overall Experience]))-1))/(count([qID_1_Overall Experience])+
Above(count([qID_1_Overall Experience]))-2))),count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2,2))>=.95, RGB(255,0,0),
If(([Master]-Above([Master]))>0 and (1-TDIST(fabs(([Master]-Above([Master]))/SQRT(((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience])))/
(count([qID_1_Overall Experience])*Above(count([qID_1_Overall Experience]))))*(sqr(Stdev([qID_1_Overall Experience]))*(count([qID_1_Overall Experience])-1)+
Above(sqr(Stdev([qID_1_Overall Experience])))*(Above(count([qID_1_Overall Experience]))-1))/(count([qID_1_Overall Experience])+
Above(count([qID_1_Overall Experience]))-2))),count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2,2))>=.95, RGB(0,150,0)))
,RGB(0,0,0))
I have first result and where my conditions work. What condition can I add to have all results?
Thanks,
Any ideas?