Group data as data for a month

[Anonymous]

i have a appended set of data across a few months i want to group my data such that :

(dd/mm/yy) (time)   

01/01/2022 10.00.00 AM  -  01/02/2022  09.59.59 AM   -->  January

01/02/2022 10.00.00 AM  -  01/03/2022  09.59.59 AM   -->  February

...

...

...

and the data column consist of the data and the time together,

so how would i be able to do this custom grouping,

and is there any ways such that it would calculate this range on its own? (if possible)

[amitchandak · Accepted solution]

@Anonymous , You create a new date column in your table like this that should work . You can join this with your date table and use

New Date = if(timevalues([Datetime]) <time(10,0,0) , datevalue([Datetime])-1, datevalue([Datetime]) )