Forum Discussion

Post 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

corange

Post 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.