2 weeks, 4 days ago kourosh kalayehParticipant
I cannot figure out what format to use to specify “X tick marks” when mu X axis is time. The automatic option gives me tick marks every 5 minutes, I want it to be every 1 minute.
Kourosh2 weeks, 1 day ago dgteamModerator
Part of the the solution here could be to change the automatic settings. I made an example and can see how the program switches a little soon to less tick marks for time.
To get this to display in minutes, I calculated a minutes column and then used that for the x-axis.2 weeks ago kourosh kalayehParticipant
The issue with the proposed solution is that I will miss the time stamps. Ideally, I want to have time stamps as they are (hh:mm:ss) and have X tick marks every minutes.
Kourosh2 weeks ago dgteamModerator
See if this approach works…
Here is an example that seems to have the same issue where you might want more increments shown:
You can have a column where you specify the exact location and label you want for the tick mark locations. To do this with dates you can use an expression to create a column that has the time increment where you want to place the labels.
In this example, my data starts on the 10th hour of 2020/1/1. The seconds function will take the year, month, day, hour as input and output the date format (seconds since 1970). Then I added 60 seconds increments. Here is the expression:
Change the Type to ‘Date’ to display as a date and time to check that you have the correct values. I added a second expression called ‘TimeLabel’ that returns the same TimeExpression but displays in the format for the tick labels.
In the Axis settings, set X tick marks to ‘Labels’, set the Location to the ‘TimeExpression’ and the Label to the ‘TimeLabel’.
Note that the Location and Label could come from the same column, but I think it is helpful see the full date and time in the first expression, and then format in another column.
Does this help?2 weeks ago kourosh kalayehParticipant
You must be logged in to reply to this topic.