Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sorting data using another field

Have created a concatenate field using Project Name and Date Logged fields e.g. Desktop Refresh (01/07/2021), etc. and am displaying it in a Stacked bar chart. I want to order it using the Date Logge...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    yes, as the error says: There can't be more than one value in the "DateLogged" for the same value in "Concatenate1".

     

    Fix that and it will work.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Anonymous's avatar
    Anonymous
    5 years ago

    Found the issue and have now resolved it. Thanks for your help on this.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks selimovd for the response.

 

Understand (I think) what you've said but I am trying to sort [Project Name]-[(Date Logged)] with the [Date Logged] field. *- Checked the Data model and the format for this is dd/mm/yyyyy so I can't see how that could ever return a different answer. There may be occassions where 2 different projects get logged on the same day. Is that where the problem is?

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

yes, as the error says: There can't be more than one value in the "DateLogged" for the same value in "Concatenate1".

 

Fix that and it will work.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Found the issue and have now resolved it. Thanks for your help on this.

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey Anonymous ,

       

      I'm happy you could solve that 😊

      Could you please also mark the post as solution ✔️ that helped you to make it work?
      You can mark multiple posts as solution and like this, the next person who is stumbling across this post can see immediately what worked.
       
      If you need any help please let me know.
       
      Best regards
      Denis