Forum Discussion

corange's avatar
corange
Icon for Post Patron rankPost Patron
7 years ago

Ascending order - Chart

Hi everyone,   I am stuck on something.  I have a chart representing the tenure of our employees over the years. I have used a formula to obtain the result. The formula I used is : EMPLOYMENT LENGT...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

corange what is cocatenate length? Are you using Employment Lenght  in chart? I just made small change to your formula, you don't need 2nd condition

 

EMPLOYMENT LENGTH = IF(Drivers[Concatenate Length]= "0 MONTHS", "MONTHS",  Drivers[Concatenate Length])
  • corange's avatar
    corange
    Icon for Post Patron rankPost Patron
    7 years ago

    Hi,

     

    Apologies for the lack of precision. I have created concatenate length to obtain the value of the employee tenure. The formula is as follows:

     

    Concatenate Length = CONCATENATE(CONCATENATE(Drivers[Length #]," "), Drivers[Length])

     

    Length = IF(Drivers[Length #]<=0, "MONTHS", IF(Drivers[Length #]=1, "YEAR", IF(Drivers[Length #]>1, "YEARS") ))

     

    Length # = DATEDIFF(Drivers[StartDate],Drivers[Finish Duplicate],YEAR)

     

    I am talking about the order of the legend. It is not in the rigth order. I have got other reports and there are all over the place. I have tried using the sorting function of my chart without success. Employment lenght is used in a charge.

     

    Thank you.