Tag: level of detail

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 filter selection and custom “all selection” on text marks

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

By incident, today's blog post is somewhat related to my last post and once again comes straight out of the Tableau forums where the solution I am going to share has been very well received. Apparently, this is a topic that concerns many users. The question asked was how we could show each single item … Continue reading How to show filter selection and custom “all selection” on text marks

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