nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Putting the time of day at "x" axis

Julio Amorim · 2014-12-27T10:03:09+00:00

Hello everybody, my problem is : I'm doing a chart and have it to put the time of day in any axis , so there is a comparison …

Julio Amorim

Hello everybody, my problem is: I'm doing a chart and have it to put the time of day in any axis, so there is a comparison that the rest of the result of the database(mysql) that I will receive. The problem is that I am not getting put this hour, not by the 'data set' or in any other way. Can you help me? I will be very grateful! I'll put a picture below, more or less what I want. How is the image 0-24 in hours. Thank you all.

Find more posts tagged with

Comments

pricher

Hi Julio,
 
You probably just need to create a Computed Column in your data set that will retrieve the hour component of the datetime field stored in the database. To do this:
 
1. In your data set, go to Computed Columns;
2. Add a new column, data type Integer;
3. In Expression, use the following syntax: row["<YourDateTimeField>"].getHours() where <YourDateTimeField> is the name of the database column containing the datetime value.
 
You can then use the computed column as the X-Axis in your chart.
 
Hope this helps,
 
P.

Julio Amorim

Hello Junior, I am very grateful for the answer. Helped me a lot!