Forum Discussion

shubhamamilkant's avatar
6 years ago
Solved

How to change date format in Matrix visualization (Value column)

I am trying to change date format into (MM/DD/YY) from matrix visualization table when date is in value column.  below picture shows current format.

 

 

Thanks,

Shubham Amilkanthwar

  • parry2k's avatar
    parry2k
    6 years ago

    shubhamamilkant in the query editor, you are telling the type of the column not how it should display or in other words, the format of the table, as suggested once data is loaded, select the column and change the format, see screenshot below

     

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

5 Replies

  • shubhamamilkant select the column you want to format and on column tools in the menu, change the date format the way you want it

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • shubhamamilkant's avatar
      shubhamamilkant
      Helper II

      parry2k  In query editor it is already in Date format. but when i select Matrix visualization and put date into the value column, and it does not shows same format.

       

      Thanks,

      Shubham

      • parry2k's avatar
        parry2k
        Super User

        shubhamamilkant in the query editor, you are telling the type of the column not how it should display or in other words, the format of the table, as suggested once data is loaded, select the column and change the format, see screenshot below

         

         

        I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!