Hello everyone!
I am facing the following issue. I am trying to create a calendar view.
Data Source: My data source behind the scenes is combined from 2 sheets. The 1st sheet contains just one column named date and it contains all dates of 2023. The 2nd sheet contains all the days off for multiple employees. I join these 2 datasources using the join condition 1=1 in order to densify each record to all dates of 2023 and have that calendar for every day.
View: My view is like the picture below. In my view, I am trying to fetch the value of the previous day in order to make some comparisons. When I get that value in some cases each correct but in others, it's null. Specifically for the 1st quarter, the previous values are all null and for the last quarter, all sundays previous values are null. I attach pictures to make it clear. The way I get previous values per day is LOOKUP(TYPE,-1) and for the next day value LOOKUP(TYPE,1). How can I fix this? Thank you in advance!
We would need to see how you combined the calendar data with the days off data. You may want to provide some screenshots of that too. Alternatively, including the packaged workbook (twbx) may help in getting you to a solution faster.
