Create dynamic X axis name

[Simon]

I'm creating a dashboard where I track data over time. On the X axis is the date which can be shown per month and per year. The column that the date is taken from looks strange so I want to change it to "Date". However, I want to keep the (Month) or (Year), but I don't know how this is possible. Currently I can switch between PR_AAI (Month) and PR_AAI (Year), I want this to be Date (Month) and Date (Year). Does anyone know how and if this is possible?

[David Boot-Olazabal]

Hi Simon,

Do you have a sample dxp file where we can look at?
Or a simple dataset and some screenshots what you are trying to achieve? That helps us a lot in understanding your request as well as looking for possible solutions.

Kind regards,

David

[Simon]

Hi David,

Sorry, sadly I'm not at liberty to share anything more about the issue due to company regulations...

Kind regards,

Simon

[Gaia Paolini]

Do you mean that the name of the column containing the date looks strange, or that the format looks strange.
Can you reproduce the problem with random dates, which would not disclose company data?

[Kirsten Smith (she/her)]

There doesn't seem to be a way to change the axis label in the manner described, I would encourage you to vote for this suggestion on our Ideas Portal:

https://ideas.spotfire.com/ideas/TS-I-5417
 

That being said, a "maybe too simple" suggestion is to change the name of the column from [PR_AAI] to [Date] so that's what shows up in the visualization.  If you are getting updated data from an outside source you can add a Transformation to "Change column names" so the name change is handled each time you update the data.