2 Replies Latest reply on Nov 9, 2018 8:10 AM by Gabe DeWitt

# Nested LOD, Dynamic/Uniform Chart Axis Range, and Dynamic Mapping Swap

Here are a couple neat things I've found, and how one might combine them.

Nested LOD & Dynamic Unified/Uniform Char Axis

Others have solved the dynamic uniform axis in a few different ways, but I hadn't seen anything with a nested LOD calc in those solutions (e.g.an exclude of an include).

I initially used a window_max of a sum to return the max value i needed as a constant in each graph independently,...

But, I was having trouble taking the calc the next step where it would return the max of the maxes as that constant across all 3 diagrams

Enter the nested LOD calculation...

While it took me a bit to reason how I got to to work, the resulting calculation is pretty simple.

{ EXCLUDE   [Fiscal Year] : max({ include [Fiscal Year]: ((SUM([Total Planned Costs])))})}

1. Charts with non uniform Y axis

2. Charts with uniform Y axis - adding the Axis Limit calc as a reference line in each of the graphs unifies the maximum range for the Y axis.

3. Charts with the reference line cleaned up

4. A few more unified charts to make it look cool (this group are limited by max count)

Dynamic Map Swap on Selection

The dynamic map swap will take a few minutes to figure out and reverse engineer. But, it's a fairly simple and a solid method for this style of interactivity.  Here's the link to Ryan Grojean solution to making maps drill down on selection. Also, here's a forum post about it with some discussion and shoubleshooting.

I got a lot of pleasure out of getting the map swapping to work, and I'm quite sure you will too.

Cheers,

Gabe

www.1gabe.com

dewittdifferent

• ###### 1. Re: Nested LOD, Dynamic/Uniform Chart Axis Range, and Dynamic Mapping Swap

Thank you for sharing Gabe.  You might want to put this in the Workbook & Calculation Library as a resource for the rest of the community.  Please be sure to familiarize yourself with the documentation template before posting.

Thank you

Patrick

• ###### 2. Re: Nested LOD, Dynamic/Uniform Chart Axis Range, and Dynamic Mapping Swap

Thanks Patrick. Still finding my way around the proper tableau forum posting methods...had thought this location added to said community resources...

I'll try to migrate the methods to something more sharable.

Cheers,

Gabe