Forum Discussion

alvin1999's avatar
alvin1999
Frequent Visitor
2 years ago

Date and KPI Visual

Hi, I have create a simple datatset for my scenario. Below is what I have tried: 1. Extracted Month and Year from Date column in date data type 2. Sorted the month column based on Month No  3. ...
Need Help
Vallirajap's avatar
Vallirajap
Resolver III
2 years ago

Hii alvin1999,

Try this,

Using the date column to create a date group in this group, you can change the format to "yyyy" and then it will show only the year in the date datatype. in the same way you used in the month also.

Here is the output file

Drive file 

 

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you.

  • alvin1999's avatar
    alvin1999
    Frequent Visitor
    2 years ago

    Vallirajap can you allow me to access your file?
    Thanks.

    • Vallirajap's avatar
      Vallirajap
      Resolver III
      2 years ago

      alvin1999Now that I gave you access, please check

       

      Did I answer your question?

      Mark my post as a solution, this will help others...!

      Hit the kudo also,

      Thank you.

      • alvin1999's avatar
        alvin1999
        Frequent Visitor
        2 years ago

        Vallirajap I can access to the file now. 

        May I know are you convert the date format in Column Tools > change Date type to Date/Time > Format (type MMM for month and chose yyy in the drop down list) in table view?

        For Month, I got 

         

        For Year, I got all the values are 1905


        Can you guide me please? Thank you.