How to create x-axis with datetime exactly with 12 hour difference

Question & Answer
,
1

How to create x-axis with datetime exactly with 12 hour difference. I have date time column and total

I want to achieve the graph like attached photo. If you notice, you can see the axis with exactly 12 hour gap for each date.

image
image1102×287 34.5 KB

2

Hi Team,

Any inputs on this please?

3

Hi @salagalakiran123
in what format are you datetime or what values do you have? Every hour?
BR

4

I have datetime values are in datetime format like 2023-12-01 05:00:00am. Yes, hourly basis data is there but not exactly. Sometimes, there is a data on hourly basis or sometimes it depends. is there any way can show datetime bases on 12 hour basis

5

@salagalakiran123 I don’t think that level of customization/configuration is available right now. I think it default to 12 AM

6

Yes, I thought of the same. Thanks for looking into this.

7

hi @salagalakiran123
not sure if it will actualy work, but maybe you can create a caluculated (date) field, to group the dates to 5 am or 5 pm. That you will have onle 2023-12-01 05:00:00am or 2023-12-01 05:00:00pm left.
BR