Forum Discussion
Group data as data for a month
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)
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]) )
1 Reply
- amitchandak
Super User
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]) )