Forum Discussion

Bbrown44's avatar
Bbrown44
Icon for Advocate II rankAdvocate II
8 years ago
Solved

date format in table visualization (how to keep as is and not get sub-date formats)

I am trying to use a date format variable and create a view of a date... When I click on date visualization instead of getting a date i get 4 sub-variables (i.e., year, quarter, month, day). I just w...
Tutorial Requests
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Hi Bbrown44

     

    You simply have to click on your column name so it will display dates instead of trying to create hierarchy

     

     

    -Quentin

  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Bbrown44

     

    you can found the formatting option right here : 

     

     

    Have a good day

     

    - Quentin

quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Bbrown44

 

You simply have to click on your column name so it will display dates instead of trying to create hierarchy

 

 

-Quentin

  • Bbrown44's avatar
    Bbrown44
    Icon for Advocate II rankAdvocate II
    8 years ago

    Great!!! This does work however the format of the date is now (e.g., Friday, December 01, 2017)... How do I keep the original formatting (i.e., 12/01/2017).

     

    Thanks for your help!!!

    • quentin_vigne's avatar
      quentin_vigne
      Icon for Solution Sage rankSolution Sage
      8 years ago

      Bbrown44

       

      you can found the formatting option right here : 

       

       

      Have a good day

       

      - Quentin

  • yrpsoa's avatar
    yrpsoa
    New Member
    3 years ago

    For those still confused, this is under the 'Columns' section under the 'Visualisations' window, rather than under  the 'Fields' list

  • JaneJane's avatar
    JaneJane
    Regular Visitor
    3 years ago

    THANK YOU this was driving me mad!!