X-axis Hours from 6 - 6 instead of 0 - 24

[PVosESKA]

Hi community!

I have a visual that shows a sum of rows grouped by hour and filtered by only showing the last day.

Since one production 'day' is not from 00:00 to 00:00 but starts at 06:00 and ends at 06:00, I want the X-axis to represent that.

Both Y-axis lines are from different tables, both have a relationship to the same date dimension and time dimension tables.

Any ideas how to tackle this? Let me know what more info is needed!

Thanks in advance,

[collinq]

Hi @PVosESKA ,

I am not positive as to the visual that you are using but you should be able to go to the Visualizations column and adjust the Max and Min for the range:

[PVosESKA]

Hi @collinq ,

Thank you for your response, I'm using a 'simple' line chart.

My Y-axis is showing the count of rows, X-axis is showing hour 00:00 - 23:00

I would still need all the hours though, just a different starting and ending point, on top of that it would display 2 days instead of 1 (january 1st 06:00 - january 2nd 06:00).