# Level of Detail

## 2021 Week 31: Can You Find the Needle in the Haystack?

Introduction The ability to efficiently find the proverbial needle in a haystack is worth its weight in gold.  How many times has a key stakeholder asked you to give them a shortlist of products (insert the focus of your analysis) to focus on for business improvement/optimization opportunities…and they’ve asked you to get back to them …

## Week 12: Can you do Comparative Quantity Analysis?

The Fixed LOD gets a lot of the spotlight in tableau but we shouldn’t forget about its cousins INCLUDE & EXCLUDE. Have a go at this challenge to practice use those functions.

## 2019 Week 24: Can you build a side-by-side bar chart?

This week you need to build this side-by-side bar chart. There are a couple of tricks but you should be able to do this in under 30 minutes (for real!). There are at least 4 ways to solve this problem. There are also two problems an intermediate and an advanced. Challenge – Intermediate Click image …

## Week 17: Can you build an automated monthly report

A few weeks ago I had this problem: I needed to create a dynamic table that showed the last 12 full months of sales for a particular channel/category of the business but I also needed to show the month-over-month and year-over-year totals. I didn’t know how to do it right away so I asked the …

## Week 28: Order Profit

Workout Wednesday in August August is community submission month. For all 5 of those weeks we’ll have our favorite submissions as challenges. You can submit here.     This week’s challenge. Sometimes we want to look at the spread of our data, but we often end up with one or two groups that much, much …

## Week 15: Total Products by Sub-Category OR Top 5 Sub-Categories by Total Product

I’m back from a one month hiatus! Hopefully you enjoyed the guest posts from Curtis Harris and Ann Jackson. This week were giving you two options: Intermediate or Jedi. Both are a play on an olympics visualization I put together a month ago. The Intermediate requires just a handful of calculations. The Jedi looks just …

Scroll to Top