Samira LOUAGUENOUNI Posted May 3, 2021 Share Posted May 3, 2021 Hi, I want to have on my bar chart dates weekly (2/01/2021,9/01/2021, 16/01/2021,....), but on spotfire gives me numbers of weeks, how to convert this numbers to dates 'begin of week' Thanks you! Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted May 4, 2021 Share Posted May 4, 2021 Hi Samira, If the dates are presented as week numbers, then Spotfire sees the column as of type 'Date'. This means that you should be able to easily choose any of the 'date' presentation options. If you click on the weekly date column in your visualization (x-axis in your example), you should be able to see a 'flyout' triangle to the right of this column. If you click that triangle, you see lots of different presentation option, the first being the actual date value. If you select that option, the axis should display the actual (weekly) date, instead of the weeknumbers. If this is not the case, then the week numbers must have been derived differently. You can then check if the week date column is indeed of type 'date' or perhaps of type 'string'. If it is not a date, you can use a transformation to change this column's type. Once that is done, you should be able to present the actual date values on the x-axis. If nothing works, please share your dxp file. That makes it easier to have a look at the issue. Kind regards, David Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now