Skip to Main Content
Spotfire Ideas Portal
Status Already exists
Product Spotfire
Categories Visualization
Created by Guest
Created on Jul 7, 2021

Add the ability to format the date fields used on chart axis

The main reason for this request is for charts visualising data on a weekly level. Currently, only the week number is available; it would be nice if there were some formatting options for this i.e. instead of week number show the first day of the week instead ("09-Nov" for example). The same could apply for Month (i.e. month number instead of 'MMM'), 'Day of Year', etc.

  • Attach files
  • Guest
    Jul 9, 2021

    Hi Arnaud,

    Thank you for your reply!

    I understand what you're saying, and I actually tried the method you have mentioned below.

    Apologies if I wasn't clear enough - what my idea is referring to is specifically the formatting of the date on the axis. For example, in your screen shot, you have 'dd/MM/yyyy'. What I would like is to be able to format this differently i.e. to show '09-Jul' instead of '09/07/2021'. I was also thinking that this option could be placed in the 'Formatting' section of the chart properties.

    I tried to achieve this by creating the following calculated column:

    Concatenate(DayOfMonth([First Day of Week]),"-",Month([First Day of Week]))

    Where [First Day of Week] is calculated via the method described in the link you provided.

    I then created a hierarchical column [Year] >> [First Day of Week] an plotted this on the x-axis but I then had the problem that the chart does not order the [First Day of Week] correctly (i.e. in date order) since it's not a date or purely numerical field.

    Could you kindly remove the 'Already exists' flag as I don't think this is accurate?
    Thanks again for your consideration!

    Kind regards,

  • Admin
    Arnaud Varin
    Jul 9, 2021


    This is achievable using the custom expression described in this article:

    For instance, using this custom expression in the X-axis a the bar chart using a date column:

  • Guest
    Jul 8, 2021

    It would be great to have this feature to see trending of metrics by week (dates) rather than week number to be more intuitive. This feature is already available in BI tools like Tableau and users are already used to seeing week dates.