How to show filter selection and custom “all selection” on text marks

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

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

Quickie on combining index and sub totals

In case you encounter the problem that you want to number your table by using index and still add a subtotal and thereby run into this here is the workaround: Copy your dimension which you intent to number using the index. In the above example, it is customer name. Put the original customer name to … Continue reading Quickie on combining index and sub totals

A quickie on understanding table calculations

It's Christmas, the kids are super tired from the exciting day and I am the only one left awake. What could be a better way to (most likely) conclude the year than to provide another example on table calculations? Today I have nothing new or unexpected, it is just adding to the vast array of … Continue reading A quickie on understanding table calculations

Mimicing Excels sumif / Vlookup without data manipulation

Update 23 November: As some have noticed, would it not be easier to just do a window_sum(sum[hour_hours])) and compute that by Answer is: yes. The original question was phrased differently with the user asking to also deduct several values which, in retrospect was not what he wanted. All he wanted was to just sum the … Continue reading Mimicing Excels sumif / Vlookup without data manipulation

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