Dominique Feteau Posted October 25, 2019 Share Posted October 25, 2019 See the attached image. The x-axis is a column called dateaxis. It's the day of the week, a numeric value. But for some reason, in line graph, that x-axis doesn't show up in order and i'm not sure why. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted October 28, 2019 Share Posted October 28, 2019 please can you upload an example It will depend on data types and plot setup, not possible to tell from a picture Link to comment Share on other sites More sharing options...
Gaia Paolini Posted October 28, 2019 Share Posted October 28, 2019 p.s. how can the day of the week be equal to 10 Link to comment Share on other sites More sharing options...
Dominique Feteau Posted October 29, 2019 Author Share Posted October 29, 2019 So I figured out my problem. More information first. The column "DateAxis" is a calculated column that determines either the week number or day of month based on another date column. It was being returned as a string rather than an integer. However, I didn't change it to an integer. Instead, in the column properties, I changed the Sort Order to "Natural String Sort" rather than "Standard String Sort". That fixed the problem. Thanks! 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