How can we create costum time bins (half day or 12 hours by bin)

[Youcef Boubellouta]

I want to create time bins with 12 hours on the x-axis, I couldn't find the function in Spotfire, I tried the functionBinByDateTime but it's not what I'm looking for, please find attached the screenshot of barschart which i want to create.

[Fabian Duerr]

You could do some binning for example with:

BinByEvenDistance(DateDiff("hour",[your.dttm.column],Min([your.dttm.column])),12)

So, you would first calculate the time difference to a reference value (here MIN) and then bin by even distance, where your distance is 12.

But I think you maybe only want to have the bins before/after noon... For this you could use the Hour() function to check if it returns = 12:

If(Hour([your.dttm.column])

[Youcef Boubellouta]

Thank you verry much ;)