Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Adding target ROW into matrix

Hello everyone   I have matrix visual and im trying to add a target as ROW in that matrix as the below image:    Any Ideas how to create this view before the actual values?    I have sear...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    I tried to create a simple model, please check it. If you need to sort the Taget rows, you need to create a second auxiliary column to assist in the sorting.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Anonymous,

 

I suggest you create a new row with the same columns as the table that you are using to pull the rest of the fields in your matrix. Enter the values that you want as target and then append that row to your existing table. You can create a sort column to keep your Target row on top.

 

Works for you? Mark this post as a solution if it does!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your reply.

    This idea was in mind and i tried to achieve it but i stuck with the column format issue, since the value of the column is number and its needed for calculation when i add <15 mins it shows as an error 😞