Charticulator - cant set Time format for X-axis (can't change from Categorical to Numerical axis)

[JanRak]

Hi

(I'm not the first person trying to solve this problem). Hope someone from the community can help with this!

I have a data table with a column "Time" of type Time:

X-axis in the chart is displayed as following (would like to have HH:MM or HH:MM:SS)

Field Time is set as temporal (tried different types as well):

X-axis is Categorical:

I've read that I need a numerical axis to be able to change the tick format.

How can I change from Categorical to Numerical X-axis? Or is there another way to change the X-axis formatting?

Any help would be much appreciated!

Cheers

Jan

[JanRak · Accepted solution]

Ok, I found the solution. What I had to do is to drag the Time field (set as temporal) to the X-axis, and now the X-axis switched to a Numerical type. 

Result:

Hopefully, it will be useful for someone in the future!
Cheers!
Jan

[JanRak]

Thank you @amitchandak . I'm afriad these options might not be available on the Charticulator visual.
Not sure, but thinking that the only solution is to build everything again from scratch.

[amitchandak]

@JanRak , On the normal visual you have option for continuous axis

https://www.burningsuit.co.uk/blog/using-continuous-x-axis-column-charts-year-and-month-labels