How to show the selected time frame and a warning if it is broken

A quite common request is to display what the user has selected within a filter. In our today's case what we will do is to show within the header the selected date range plus a warning if the dates have a break in it. That is, if the user selects January, February and April, the … Continue reading How to show the selected time frame and a warning if it is broken

A bit about the order of operations – Part 2

Here is the second and concluding part of the mini series on diving into the order of operations based on workout-wednesday 2022 week 15 challenge by Erica Hughes. In Part 1 we rebuilt the solution that was in the challenge but this time our aim is to avoid using hard-encoding the maximum date or storing … Continue reading A bit about the order of operations – Part 2

A bit about the order of operations – Part 1

Wow, it's been more than a month since I last published something. So it is more than time to get going again. This time, we will do two things: first, revisit workout-wednesday challenge 2022 - Week 15, rebuild it and discuss the challenges related to the order of operations. Then, in Part 2 of this … Continue reading A bit about the order of operations – Part 1

Keeping a constant number of returned rows

In today's question we will be answering how we can keep the returned results limited to a defined/definable number of rows. That means for example if we say we want only 200 rows to be returned but we have four different segments then each segment should only hold 50 results. If we increase to 300 … Continue reading Keeping a constant number of returned rows