FIXED Level of Detail Functions (LODs) let you specify the level of detail you want to aggregate a particular measure at. This allows us to work around the natural limitations of the level of detail in the worksheet we're working in.
FIXED LODs are a great place to start as they are the definitive, essential LOD. The two others (EXCLUDE and INCLUDE) are less common, but functional in their own unique ways. If you want to simplify and just learn one LOD type, FIXED is the one for you!
Do you want to build a customizable, dynamic date range filter in Tableau?
For example, imagine you want the filter to default to the last 14 days ending with today's date, but you'd like your user to be able to adjust the end date and number of days in that filter.
That combination of functionality is not available out-of-the-box in Tableau, but with some creativity, parameters and calculations, it's possible!
How do you add a Quarter and Year list filter in Tableau? By default, Tableau lets us add a Quarter Number filter (e.g. Q1), but getting a Quarter and Year filter list isn't a standard option! As a result, we need to workaround this a bit with three possible options.
Which one works best for you depends on your use-case, but all three will be helpful to know in your Tableau work.
One of the primary purposes of a dashboard title is to provide context for users. It should give them a sense of what they are looking at, and what they are looking for.
My favorite way to add value to a dashboard title is to have it reflect filter selections. For example instead of saying "How is our hospital system performing?" it could say "How is Trinity Northern performing?" when the dashboard is filtered to a single hospital.
Do you want to incorporate password protection for your Tableau Public Dashboards?
Using a parameter and a random string generator, you can get pretty close! While not totally comprehensive, it's a great element to incorporate into your dashboards if you want to keep them somewhat secure without investing in the Tableau Cloud services for a wide viewer base.
Filtering on a date range in Tableau is pretty straightforward, right? But how about if you want to filter on that date range AND you want a comparison date range filtered at the same time? That's trickier.
For example, you set a filter from January 1st to March 15th 2024 and you want a comparison period of January 1st to March 15th 2023 to automatically be set, how do you do that?
Need to hire a Tableau Developer? We can help!
Hiring someone is a daunting task! How do you find the right person? How do you know if they'll be a good fit? How do you assess their experience level?
We've partnered with Tableau since 2014 to facilitate training sessions and consult on Tableau projects. During that time we've trained thousands of users and helped hundreds of organizations maximize their use of Tableau.
We're often asked to help those organizations with the hiring process. In this video, we've distilled some of our biggest takeaways that can help you find the right candidate for your team!
Can you make a Tableau Public dashboard private? Kind of!
In this video, we’ll look at a great alternative to hosting a dashboard on Tableau Cloud! You don’t need to purchase multiple licenses for the viewers of your dashboard. All they need is the URL!
While not as secure as a Tableau Cloud solution, hosting a private dashboard on Tableau Public can be a viable alternative if your data isn’t extremely sensitive, or you have a large viewer-base.
Do you need to publish public Tableau reports but suppress small populations because of sensitivity concerns?
If you work in healthcare, education or another government entity, there's a good chance your Tableau reports contain sensitive information that needs to be suppressed. For example, many organizations we work with need to suppress populations when they are less than five. For example, if we filtered a courts dashboards to see how many court cases there were in Whatcom county for 12-14 year old, Pacific Islander females in 2017 and there were three cases, we would need to suppress that figure because it's less than five.
Want to ramp up on Tableau quickly? All aboard the OneNumber Express!
We’re excited to launch the OneNumber Tableau Training Passport! This passport gets you unlimited access to our five Tableau classes for a 6-month period and includes an individualized session with Eric or Ollie.
Text tables can be overwhelming for users. It's hard to know where to focus your attention!
Where are the highest and lowest values in the data? What patterns are there? Upgrading a text table to a highlight table can often do wonders, but a highlight table doesn't provide a singular focus. It will likely highlight high, and maybe low values too.
That's where a custom highlighter can be so handy. Why not let you user control which values they want to call attention to?
Do you have an object in your Tableau dashboard that should be expanding and contracting but isn't?
There are a number of reasons you might set up an object to expand and contract. Maybe it's a detailed sheet that should only display when the user makes a selection from the summary sheet at the top of the dashboard. Maybe it's a parameterized worksheet swap. Maybe you've set up a simple show/hide button for your user.
Regardless, when an object is in a layout container and isn't expanding and contracting as desired, it's frustrating!
Normally, when using a parameter to swap between measures, you're limited to using a single number format in a text table. But what happens when using the same number format makes no sense?
In our example, we're swapping between Total Cost (reported in $) and Visits (a count). We don't want to report Visits as a dollar-denominated amount, and we don't want Total Cost to be reported without a dollar symbol! So what can we do?
Adding comments to fields in Tableau is important to document your work and keep things organized!
For example, you might have two fields with similar names! Adding a comment to them can help you quickly distinguished them in the data pane.
Need to get some Tableau training for yourself or your team? We've got you covered! Whether you want to dive deeper on Tableau Desktop, Tableau Prep, Calculations or Dashboarding, we've got a class for you!
In Winter 2024, we're teaching 12 public classes across Pacific, Eastern and Central European Time.
Have you ever been asked to include a table of data that’s way too detailed for the dashboard you’re working on? Sometimes we really just want to see all the numbers. But we might not necessarily want to display all that information at once.
That’s where a Show/Hide option could be effective. Using a parameter, we can enable our end-users to select whether they want to see all the data in the underlying table, or just some summary data (like some total columns).
