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 searched alot to achieve this but couldnt find any helpful results. 

 

Thank you in advance

  • 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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your efforts trying to help me.

      It looks promising but im trying to adding to my model n for some reason i cant get it running, i guess its cuz i cant apply in the same way but i will try again. 

  • Shaurya's avatar
    Shaurya
    Memorable Member

    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

      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 😞