Forum Discussion

acretney's avatar
acretney
Frequent Visitor
9 years ago
Solved

How do i sort a column with duplicate values by another column

Hi all,   I am trying to create a 'stacked bar chart' visual that will show me financial information corresponding to tasks coming from a project plan. (See below)   The tasks are currently...
Need Help
  • acretney's avatar
    acretney
    9 years ago

    Thanks Angelia,

     

    That fixed the calculated column however when i try to sort the 'taskname' column by it i get the following error

    "This column cant be sorted by a column that is already sorted, directly or indirectly by this column"

     

    I've actually implemented a workaround by concatenating the 'TaskIndex' and 'TaskName' values and sorting by this instead. So now i have..

    ID1 Establish routine

    ID2 Set Trap

    ID3 Drop Anvil

    ID4 Chug a beer

     

    It's not ideal as i would prefer the task ID not to display in the visual however at this stage its a cosmentic issue rather than a functional one.

     

    Thanks anyway for your efforts

     

    Kind regards

    Alex

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi everyone!

 

I have the same problem is described in this chat, but my data is organized in the same way that the solution provided. The error I get is that I can´t show the value as a percentage because a couple of rows are empty. Also, I can´t sort them because a couple of values ar equals. Why the error is still turning up whether "Axis-Copy" has no duplicate values?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thank you in advance