Tag: lod

Changing date granularity based on filter (!) selection

by Steffen, posted in Filters, Level of Detail | LOD, order of operations, Parameters

For today I have an interesting one. Let's assume we are faced with a request where the circumstances allow you to show a maximum of twelve bars in your chart. Reason isn't relevant, let's just stick with that as a prerequisite. At the same time, you are tasked to provide the most conclusive yet granular … Continue reading Changing date granularity based on filter (!) selection

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

by Steffen, posted in Design & Layout, Level of Detail | LOD, Table calculations

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

by Steffen, posted in Filters, Level of Detail | LOD, order of operations, Table calculations, Workout Wednesday

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

by Steffen, posted in Filters, Level of Detail | LOD, Parameters, Workout Wednesday

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

by Steffen, posted in Level of Detail | LOD, Parameters, Table calculations

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