Forum Discussion
Solved
Insert an index for a time range
Hi Team, have this question for you guys regarding a sort of index column. I have this (simplified) dataset for you, where the date range is expanded into different rows in order to reflect the ...
Hi PhilipTreacy and ryan_mayu
As i needed to do that at query level (the next step was to merge a query with that column) i created a date difference between Operation day and service start +1 as Custom column in order to achieve "day no" column.
The added column with RANKX was another idea I used as at the very beginning!
thank you for your hints
PhilipTreacy
Super User
Super User