nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating Drill-Down Graphs in Graph Builder

Ryan_Gilmore

brewery by state - 2008 - 2019 production volume - stacked.jmp

Comments

Emmanuel_Romeu

Hello Wendy (@wendytseng), I love it. I'm newcomer in the company and have to admit I did not used such features in my previous job (focusing on DOEs). By the way my previous company is located in Chaska, MN (I was located in France not in the "land of 10000 lakes") and I've been in some breweries in Excelsior as well as twin cities ! Thanks to your nice talk I'm know able to do such fancy graphs.

However on the third lawer all states appear and when I click on your script there is all states as well .... is there something special in my settings I should care about ? thank you for the help. Emmanuel

wendytseng

Hi, @Emmanuel_Romeu ! I'm so glad you downloaded the table and are utilizing the data. I am also glad to hear that you have been to our state! The Excelsior area is a fantastic place to visit! I am not too far.

Can you take a screenshot of what you are seeing and tell me which script you are utilizing?

By the way - I am always looking for collaborators on building out a rich brewery data set so if you have methods/sources of acquiring this type of data please let me know!

Emmanuel_Romeu

Hello @wendytseng

I tried both scripts "Drilldown ... in US" and "Brewery Trend Drilldown" and both returns me the same graphs (see below) when I go through MN as instance

The reason why I'm suspecting something wrong in my settings ...

Emmanuel

Emmanuel_Romeu

Hello @wendytseng ,

I've got it !!!

I initially set my language preferences to French to present to our customers in their mother tongue,

When I set back to English, script works properly.

Depending on settings on A) "Windows specific - Display language" and "General - Save scripts" & "General - Displays indexes" I obtain different graphs ...

Note, that is the case when I redo the whole sequence by myself saving my own scripts.

As instance

Case study 1): for A) English and selected (thus in english) everything goes well. It is what you presented and I'm able to repeat identically (thank you for the nice video).

Case study 2): for A) French and selected (thus in english) Graph 1 & 2 are correct while all States appear on graph 3. It is what I mentionned in my previous mails.

Case study 3): for A) French and deselected (thus NOT in english) Graph 1 is correct. On Graph 2 bars do not appear thus I do not have access to Graph 3.

Emmanuel