Hierarchies and other unique spatial visualization - Certified Flow Designer Training Session 3 transcript

Shared Flows 

 wow all right so I didn't get a chance to do as many 

 um analyzes as I wanted to but I didn't have a pretty good start on uh looking at the Airbnb Destiny density of 

 California's population centers so this is mostly going to look at the San Francisco area LA and then San Diego 

 down here um I've colored the each of these dots represents an actual Airbnb BNB location 

 and I've colored them by price so to get a better look at the price and 

 each area we can go ahead and go into the next slide and we can see that majority of them are down pretty low but 

 there are quite a bit that are pretty high up here so if you look at this one as an example um we can see this is in Beverly Hills 

 and it's 25 000 a night for that location so um that's quite a bit but um 

 but yeah if I just kind of Click around here you can kind of see that you know there's a bunch of different options and varying prices 

 um I can go up here to San Francisco huh um but yeah and then the great use of the 

 interaction and the uh um on selects uh overlay texts that 

 looks really really good yep and the next slide I wanted to look at 

 um that price versus the number of reviews and then the actual room type here so naturally we can see that 

 obviously the lower prices have a higher number of users there's maybe some more people that go there but it's kind of 

 interesting to see the as the price increases and we can see like where those different areas are at with 

 different room types so yeah fascinating um wow this is a great data set and 

 great visual um there's two comments I have um one is that for this visual on the 

 depth Axis or sorry the width axis for Price uh you do have the option for log log scale so for data like this it might 

 help reveal a bit more of what's going on sort of at the lower end uh 

 but I think that's amazing and then on the Second Step um if you want to jump over to that one 

 yeah um the one thing I noticed was the 

 the dots seemingly above the map a bit I'm not sure if that was intentional but I just wanted to make sure 

 um you as well as other people were aware of the button or where that setting is but you'll notice that by default it actually is like hovering 

 over just a little bit and if you click on the edit button which is that little pencil icon that will take you into edit 

 mode um is that little offset from map um it's right inside of charts uh yeah 

 right there so by default that's it's at 0.01 and if you set that to zero then 

 the dots will basically be on the the map itself okay and so so anyway it's 

 just like it's less about uh critiquing you and more for everyone else's edification 

 um in case they've encountered somewhat of the same uh four Maps yeah I didn't notice that and I wasn't sure how to fix 

 it so I appreciate that thank you yeah of course and then one last sort of uh and this is my personal uh design take 

 is that for the connections themselves here if you select the um connections 

 that um whenever you have a lot of density um like this 

 um one bar will sometimes obfuscate others and so you can change the opacity of the color here 

 um I do something more like 60 or 70 um I mean there's sort of anything's available but the uh it's in the colors 

 section um and that opacity will essentially allow you to see through a bit of the 

 this the uh the connections and so it just makes it a little easier to sort of 

 navigate and see and but that's just a personal design preference since um 

 takes um really awesome presentation cool thank you yeah that's great did you 

 get the map off our of our help center yep so the the map of California came 

 from your uh your U.S states 

 Google Drive yep great yeah very nice 

 thank you right anyone else like to present 

 oh girl all right go ahead how so I um this is uh really quick because uh I 

 after last time uh the presentation uh Bill did uh I think that was a really 

 good way to learn how to create a present uh visualize uh uh Geographic 

 data so I just replicated it in front of my students to give them an example of 

 this and uh so I expended a little bit um you know just to for the homework uh 

 let me see how do I share my screen I want to share screen uh Google Chrome 

 um share sent 

 okay um so this is uh uh basically what oh 

 can you see this yes okay so so this is uh what bill 

 created uh during the last last weeks uh basically 10 000 cities and uh it was 

 uh the photograph I think for the color of the map and uh I went a step further 

 uh was this to kind of aggregate um the population of cities into each 

 for each country so obviously China would have the largest population city population uh so each country would have 

 their own uh one dot per country like you know like this so and then I went 

 one more step to look at it based on um you know 

 um different continents so it's the casino of Asia as the most population Oceana 

 New Zealand Australia has the um least population of city in cities 

 that's it okay and these are the continents that the 10 000 cities 

 um exist on yes so there's ten thousand dots on that graphic 

 uh uh yo I I created a snapshot so this 

 is population by I aggregated uh okay yeah 

 so that was uh yeah my next question is if you did aggregation in the tool or outside and it sounds like you used the 

 tool to create a snapshot which is great because we're actually going to cover that a bit today um in the snapshot so that's uh really 

 cool that you you did that um it was quite easy to do it just uh you drag a a column up to the on the 

 title bar and it just does it for you yeah yeah absolutely um 

 yeah I'll I'll show something in just a moment here that is related to that um but before we do that any other 

 commentary for anyone else that would like to present yeah I just wanted to say we love it when people take these 

 flows that we put out there and extend them and make them uh more comprehensive 

 or give a Different Twist to it nice going 

 um I'd like to present mine that's okay yeah go ahead Henry okay uh we'll get it 

 up this is from a data set that um I'm a 

 big fan of it's the exoplanet data from NASA um so to start out with the field like 

 all these dots represent a star that we have found uh planets orbiting around 

 um you move forward and they all congregate onto the globe and this is all the locations of the observatories 

 uh that actually were responsible for finding these exoplanets uh then we move 

 on to the next one and this is all the locations of the exoplanets in the sky 

 around us so like if you look up at the sky from Earth depending on where you are around the Sun like this is the 

 globe around our solar system that we have found exoplanets from and then the 

 next step uh it actually has distance data so uh now all of the dots are 

 actually arranged via the number of light years they are away 

 um from our location so um that's that's what I have so far I 

 have a couple other charts that I'm still working on uh this one's pretty good this is all of the uh single 

 location stars that we found um or the observatories that have found them uh Kepler which is a Space 

 Telescope is way ahead of everybody else still uh so that's and uh so that's that 

 it's it's kind of difficult because the Kepler bar is so large I need to find a way to like get it in screen and still 

 everybody else and then um and then this one I just started working on the other 

 night this is all or this is is the um kind of breakdown of the stars and how 

 many planets they have around them so like the larger circle is the ones we've confirmed one planet and then I believe 

 it goes all the way up to eight currently we found one start with eight planets around it so uh that is that's 

 something I'm going to continue working on I was actually working on it before this class started but wow it's a really 

 fun data set and it's always growing too which is super fun yeah yeah where'd you get that data set 

 um just search for like NASA exoplanets they have a great page with so much information that's the best part about 

 government agencies they just put everything out there so wow 

 that is incredible um yeah that was really really awesome uh both from a Content perspective but 

 also the visuals the uh the colors at the end I noticed a few red as well there's uh green and red 

 does that have any meaning that that did I have already forgotten what it was though okay okay um how did I do that 

 that was oh that's the that was the planet numbers I don't know that's the size the oh the colors were the system 

 distance that's right um yeah it goes from like 1.3 light years like 8 500 or something like that 

 and um if I recall correctly the visual where you had the the dis like the 

 exoplanets a set distance away you actually still use the map function to 

 set those distances right so I think what's I love this one where it really extends the idea of like what is the the 

 um a map here where it's a map of the Earth but now we're taking it and using those distance measurements to share 

 something uh as more of like in space as opposed to a dimension of like 

 population like household so um I love the different ways Maps can be used here we've seen quite a different quite a few 

 here but I love that Visual and I don't know what you're thinking for that last one if you're thinking of like a pyramid 

 look um that might be cool yeah but uh right now I think they're overlapping and and the one little button I'll just hint 

 towards because you might um encounter it um or it's it's sometimes a little 

 tricky to find is within additional Dimensions there's a little field called Direction and it basically says in what 

 way does it disperse vertically horizontal or through the depth Dimension okay so I'll just point you to 

 that play with that and that might help help on that last step but uh okay yeah 

 that was awesome that was awesome guys those are amazing presentations from 

 everybody uh just kind of Blown Away uh with the start of this so you guys are 

 starting the bar high for me to dive into hierarchies and so um I'm a little nervous but that was 

 really cool um and if you guys are open to it I would love to start um sharing these with other with more of 

 a larger population so we can talk separately or I'll probably email separately uh Jessica's uh take on that 

 but uh to be able to amplify and and showcase some of these I think would be well worth it Diving into Hierarchies 

 um so for today we're diving into hierarchies um and specifically the one we are going 

 to dive into together um actually close this one is related to 

 creating a balance sheet um and so I point to a balance sheet because it's sort of a very easy way to 

 think of a hierarchy relationship um but in a way that you don't typically Balance Sheet on Hierarchy 

 see a balance sheet shown um and so here we have assets and liabilities and shareholders or 

 stockholders equity which should always be equal to each other that's why it's a balance sheet that the number of assets 

 should equal number of assets Plus or liabilities plus shareholders equity and 

 So within each of these this first view you can see sort of the the big picture in some sense the 

 um the hey Mike a full span here yes can you go full screen yeah is it um let me I just have you in 

 your in your uh box sorry okay yeah let me uh I'll present 

 this way because I know the text is a little um yeah thank you small here but um yeah 

 and so each of these outer components is uh one of the line items So Good Will 

 um sort of the the list goes through and this uh company is actually T-Mobile um if I go more to the side here and uh 

 we'll play around with some of the the ways to to visualize this and rotate it but 

 um I thought some of the interesting aspects uh to this um one were the the really large values 

 here on the asset side was Spectrum licenses so 82 billion dollars worth of spectrum 

 licenses so the license for that area of spectrum that they own is by far their 

 their largest assets um and where was the other one 

 I can't remember the other one was or what the other Insight was um I guess long-term debt but that's not too surprising but anyways um what 

 you'll notice here is one there's somewhat of a snakey design here where we're using 

 um lines or area charts to connect these data points together the height here is 

 equivalent to the dollar amount so it's essentially a bar graph on one angle but 

 it's also a hierarchy showing the relationship back to the the center and so we'll show this through a variety 

 difference means but you can also show this not just in a circle but also 

 vertically here and this might be a little easier to to see and understand 

 um and I can actually rotate this as well um oops 

 yeah wrote this is 90 degrees and that also sometimes aids with understandability 

 um so we'll go through basically the the creation of these um and one thing I'm just going to note is that it's a little 

 more technical but I think we'll uh in the process learn quite a lot around how Fixing a Flow in an Error State 

 to actually um and it looks like this might have gone into an error state so 

 if your flow ever gets into a state where something doesn't look right I recommend refreshing the page 

 or save and refresh and that is typically an artifact of the preview window this is a preview window of the 

 presentation um and that then when you go through playback um it's a it runs the script again but 

 it's anyways sometimes you can get into a state where the preview window is not accurately reflecting what the 

 presentation view will look like so that does happen on occasion so anyways that's the the visual that 

 we're going to go through and start to to create and so this can be applied to a balance sheet a cash flow statement an 

 income statements a hierarchy of information and even to our points of of being able to show all the different 

 areas of flow so still sort of a work in progress and a little large but these 

 are something bill and I have been working through these are all the top level areas uh that we are covering the 

 flow homepage you guys have gotten very familiar with most of our work here together has been within swarms and 

 different components of swarms will probably very quickly go through quite a lot of these other groups for images 

 texts and models and sort of things just to check the box but we'll hopefully get 

 be able to share this out with you guys and we're marking down what we've gone through already what we have yet to go 

 through that way you can sort of see the the whole Gambit of of what is available Nuances of Labels 

 the one thing to note and something I will acknowledge that we are still working through is labels have a lot of 

 nuance to them you'll notice that the labels here are radial in in pattern 

 where they radiate outwards um aiding in their ability to be deciphered but there are some issues 

 like right here that you know is just because of the crowding of information 

 um in that x-rap might be on so we'll cover some of the edge cases of what we're working through um but uh but how we think this is going 

 to be unlocked is with templates which are coming out soon where we're not 

 coming out soon but is something I think you guys will be more heavily involved in where after creating some a flow like 

 this like a hierarchy that is more detailed that we can save it as a template that then allows anyone to 

 upload data that has a similar format to reuse basically the perspectives and the 

 colors and and some of the other characteristics but with the different data sets to help someone get going 

 because as you'll find out your original you'll see here there's a few components to building one of these that's 

 important for for us to know as as sort of the core designers here um but we'll note that they will get 

 easier with templates so with that let me actually start to dive in 

 um and so for this first let me reference how you can actually get to this data so once again going to our 

 data Library we will be using a training data set for T-Mobile 

 so this is within your demo media and assets folder which I'll Place into the 

 chat window again um on the chat window 

 here we go and 

 oh and Mickey I just saw your message sorry um I'm so sorry we skipped over you if we have some time at the end 

 let's make sure to have you presents um um yeah let me finish this thought but 

 uh we definitely won't don't want to miss your presentation so apologies for that okay so let me go back here 

 um yes so I put that into the chat window so this is going to be inside of training data sets 

 um and we have T-Mobile financial statements and we have it saved as a Google sheet so that everyone can 

 basically look at this data first as well as we're going to use this to import in to look at a few things so 

 essentially what we have here is each of these is the line item on a cash flow or on on these reports and that each of 

 these can be categorized into a larger category and then a subcategory and then the details for for each as well as we 

 have this information both for the year 2020 as well as 2019. we have the dollar 

 amount here in millions and then I've actually gone ahead and multiplied it out by a million to show the real value 

 here since when we have the auto rounding inside of our our system 

 um it's uh it reads this still is 82 000 um as opposed to 82 

 um a trillion or billion um so anyways is there any particular way that 

 you're organizing that in terms of you know top down Long Dataset vs. Wide 

 yeah so the most important thing is that this is a long data set rather than 

 locked and wide and what I mean by that is that you could very much very easily also see this information depicted this 

 way where you have 2020 as one column and you have 2019 as a separate column and that's totally fine you could 

 actually do it that way just recognize that 2020 will need to be its own swarm 

 and 2019 will be its own swarm and if you wanted to combine the two in either 

 uh hierarchy or to show something over time that it needs to be in its own Unpivoting 

 column and so that process is called unpivoting and if we get more into the 

 data transformation that's a whole whole bag of worms that is a little outside of 

 the scope for what we're going to be covering um but definitely is is somewhat necessary here but how you actually get 

 this to this data is kind of cool I think is you can actually get this from the SEC website so if you go in to the 

 SEC go to filings you can go into Edgar and actually search search for a company 

 or fun name so we can type in T-Mobile here 

 and once we open that up we can open up the 10K and we'll see the 10 cues make sure to 

 click on the 10K and specifically open the filing that was made then then click 

 on interactive data I know there's a lot of like clicks here so interactive data 

 and then there's a little button that says view Excel documents I think it's kind of hidden with your system but uh 

 that's okay because at the end of the day you get a pretty impressive or you get a document that contains 

 pretty much everything you need um so here we have the the data and we 

 have all of this on different tabs and basically we can use this balance sheets Column for Category 

 uh to take what is current liabilities and what we would do is actually add 

 over to it so that we have a column for category 

 so this would be assets and then I'll create another call or one 

 called subcategory and this is current assets 

 and so what you're seeing me do is essentially categorize all of these 

 um and I will not include the totals so we would not include the totals here since we don't want that to be part of 

 the aggregation but I do the same thing for liabilities 

 and I'm just going to skip ahead here um the there's also long-term liability 

 it's not just currents but I'm sort of skipping that categorization since we 

 already have the data I just wanted you to know where you can get it because you could do this for any balance sheets and 

 lots of information so now that we have that downloaded 

 um what we'll do is copy over this URL and on inside of flow we are going to 

 click on select slash upload the loader type we're going to do Google spreadsheets and paste in this link and Importing the Data 

 when we import we will import that data that data in 

 and we will then very quickly click on edit slash re-upload in the future there 

 will be a button called Data transformation that will take you basically to the same spot and the thing Snapshots 

 we're going to focus in on is snapshots um because this is where we are adding the categorization or the the creation 

 of the hierarchy by creating groups so there's little row groups here and how sort of mentioned it last earlier but 

 essentially what you do is you drag and drop up to this little section that says drag here to set row groups and so I 

 want to drag them in order so I want to have category on top and then I want subcategory beneath that and So within 

 this you'll see that there's been updates already so we can see assets here and if I click the the carrots I 

 can see that there's other assets and current assets and I can explore each line item so I've already grouped things Value Aggregations 

 together and then I can perform aggregations so I can take the real value and go to 

 Value aggregation sum so now I'm summing up each of these line items so that at 

 the next level you're seeing the additional amount and so I'm going to do 

 that here for Value as well 

 and I'll skip through sort of the other ones um you know one other one we might do 

 here maybe just for category no Optical leave it like that actually 

 um and the most important thing to do is to click this great snapshot button so I have to set it up you want to make 

 sure to take that snapshot of the information and so the now that is saved in that manner Sorting a Column (Ascend or Descend) 

 um the other thing you can do as well as sorts so just by clicking on a column you'll sort it up ascending or 

 descending and that's does impact the visualization and the order in which the 

 uh columns appear so from here we've created a snapshot 

 and so if I close this snapshot is right below data source 

 because there can only be one snapshot per swarm you can't you can create multiple snapshots but 

 um you can only have one snapshot per swarm so that snapshot carries through to the different steps and I didn't 

 cover this in the morning session yesterday and I I realize I should have but I want to just call out sort of how 

 this is structured by showing it first in a scatter plot and then we'll jump into uh hiring so the first thing to Hierarchy level 

 know is that there's some automatically created Fields called hierarchy level 

 which is basically one two three um based on where it is on this uh in 

 this data set where we have three levels the the top level the the sub subcategory and then the actual line 

 item um and so um on the Heights I'm just gonna put 

 um I guess value sure that'll be fine now the depth axis I will put a hierarchy 

 group okay so hopefully this will start to make sense 

 um in just a just a moment here uh if you bear with me so basically there's 

 three levels of the hierarchy and uh maybe it's just to call out that there's a field called hierarchy level I'm 

 actually just going to switch back over to to hierarchy because that's actually how you typically create these all right 

 so this is hierarchy um and it by default starts with a circular layout you can switch that to a 

 linear layout which I think let's just start with here and then we'll switch to Circular in a moment 

 um and so this is level one this little dot here on the always left level two is the middle and level three is this third 

 one and that relates to the data um where if I go to snapshot one this is 

 level one uh level two and then level three is actually each line item so each each actual line item there so I do not 

 need to bring in detail up into the grouping um it's not necessary for to 

 add the actual line item um onto the hierarchy okay so from this uh we might want to Colors 

 add some colors um so we could do this in a number of ways one thing we could do is do a color 

 scheme um based on let's do this based on category okay this is 

 actually a good example of where you might get confused and let me just clear this up a little bit so 

 you'll notice that we see the first and the last levels but are missing level 

 two and we selected category and if I select subcategory we'll see level two but are missing level one because what 

 we're trying to do is apply a color scheme based on the data that is contained there based in based on the 

 subcategory here and okay and so 

 um if you look at the snapshots you'll notice that um for category there is no category 

 listed at this top level for assets or current assets um 

 um yeah and and so the way to remedy this is to have these filled in and so 

 we can do that by going to Value aggregation first um and a little bit of a uh yeah 

 something to a small detail here it's a easy to miss but 

 um but yeah is something that's you might encounter and so now essentially we are coloring this based on the first 

 one it sees as opposed to being actual representative of what subcategories are 

 really there so it is somewhat forcing it's as opposed to being uh truly 

 correct so I don't know if that all makes sense to everybody but I sort of want to call it out um as one way to uh to do this Labels 

 okay so to help you understand what's there let's add some labels so on this 

 snapshot or on this swarm we're going to click on new labels and the first thing we'll do is click on hierarchy group and 

 hierarchy group basically takes all of the hierarchy levels that are not the last node level and adds the name to 

 them so this is whatever was grouped on so here we have assets on the bottom we have liabilities and general Equity up 

 on top um and if I want to put labels on the Node 

 level that I need to create another label object and I can do that by duplicating this or if I go back to the 

 Swarm I can also click on new labels again and this will create another labels asset and on this label I want to 

 bring in the item which is the very it will only exist at the node level since 

 item does not appear at the at the upper levels and so you'll notice that the 

 text is all running into each other and a bit difficult to read so what we'll want to do is first turn off wrapping 

 this will make it so the text does not wrap to a new line and then in addition 

 we might want to reposition this information so we will want it left sent 

 left of the dot and be on the center of the dots and 

 um this I believe might be an instance where I just need to save and refresh um so let me go ahead and save control s 

 and if I refresh um there might be something just going on with the preview window for labels 

 which I've mentioned have have a little bit of uh stuff going on so yeah you'll 

 see that the the font or the the labels are now resolved 

 um and I'll space these out just a little bit by adding some Heights just to call out sort of these little 

 components that you can start to Intuit these uh account for the 

 um measurements of the size of the this hierarchy um both in width and Heights and this is 

 controlling where you're placing the spacing of of this information Connections 

 um so the last thing to do here is to add in some connections so what we're going to do is actually add connections 

 based on I'm sorry we're going to click on connections based on hierarchy level 

 so it's a little drop down based on hierarchy level and that will create the connections based on those hierarchies 

 that we assigned now this is sort of uh I think pretty interesting and uh 

 putting more more typical for 2D view um you know there might be more you'd 

 want to do for some of these labels some some sort of Tricks here are are to bring it out a little bit so that it 

 stands in front and you can also add a background so if it is obfuscated that 

 you can make it a little more clear to to read through by adding in backgrounds 

 um but the the thing I wanted to really highlight here is I will add another step is that in three dimensions you can 

 actually use the height so here what we're going to use for Heights is that aggregated 

 um and actually I'll use just regular value in this instance but now you'll 

 notice that the dots are offset based on their aggregated real value 

 and the thing that we've been sort of uh encouraged people to do is to create an 

 area chart from this so if I click on new area charts an area chart is a 

 little different than the connections back to the 

 axis in that it fills in between data points as well I mean somewhat of like a 

 Sankey kind of way where you're seeing the distribution I'm going to alter the 

 size of this just a little bit here to make it a little less tall so you can more easily see 

 things and the one thing you might also want to do from this is rotate it so if I rotate 

 this minus 45 degrees along the width axis makes it just a 

 little bit easier to see some of that depth now the reason I'm not going all the way to minus 90 degrees 

 is that's at least for looking at it straight on the texts sometimes are 

 overlaying each other so we could have a whole lesson just on labels and and formatting and stuff like that and we 

 might but I think what we'll mostly find is that by nepotizing these and putting 

 them into formats that really we know work that should solve for the majority of cases so that's sort of what we're 

 banking on a bit more and I think you guys are going to be more critical to that as well as some ability to interact 

 with this we won't uh have you guys do it but we have just briefly show we have a node 

 editor which allows you to create a very complex interactions where if I click on a DOT 

 here it will cause other things to occur based on whatever I set up in the node editor that's for a totally different 

 topic and I'm not going to cover that but just sort of highlighting that that will be a part of hierarchies so you 

 know last but not least here just to show how we can transform from one visual to another if I change this from 

 linear to Circular you'll see that the the switch is pretty much automatic and 

 that's uh yeah I can sort of go from there the one thing I wanted to call out 

 for radial text or sorry for um for these types of graphs that are 

 circular is that this works fine when you're at an angle here 

 um of like you know 90 degrees or something where you can still read everything 

 um but that you might especially if you get into more of like a 355 or or a full 

 circle that you want the text to radiate outwards and so to accommodate that what 

 I'll do here is on um this last line for label two let me 

 duplicate this and I'll turn off the first one and on the second one I'm going to click this little radio button Rotations 

 and I will also click enable rotation and it looks better but it still looks bad the reason it looks bad is because 

 anytime you use radial these radial buttons that you need to set the 

 position center Center Center and then you'll be at the right spot and so now these are more easy to read and still 

 face you as you rotate around the object and there's more we could do like I 

 mentioned but I will sort of pause there so I know I've covered quite a bit here with hierarchies as well as the root of 

 hierarchies which is snapshots and snapshots can be used both for that 

 aggregation buts and I realized this after the fact here I actually 

 aggregated everything for 2020 and 21. it's uh the reason being is that in that 

 snapshot one year 2020 and 2019 are both 

 there and so I actually want to filter this I mean neglected to do that and so I can easily do that here if I go into 

 here and just type in 2020 or sorry let's click the filters of 

 equals 2020. and so now this data set is only just 2020. and 

 um I clicked I was doing that to the raw data State set here as opposed to 

 snapshot so just a note to be on the right view so to be on Snapshot here and 

 then I want to filter this only look at year 2020. so now we'll update that snapshot 

 and that should Ripple through to then update all of these visuals and those 

 interactions so uh sorry about that but I'm glad you guys get to see sort of 

 this in action um so let me pause there to see what questions you have and what I can 

 elaborate on 

 Michael what other than financial data what else have you found this useful for 

 yeah so um we also have seen it use um 

 trying to think here we've seen it used in an m a transaction 

 whereas basically an org structure like here's one whole business unit as well 

 as the geographies so it was basically like Finance you know like where does Finance it or like sorry the like an 

 employee layouts um or um uh interactive org chart yeah interactive org chart 

 that's yeah a good framing um and that actually reminds me um and this is what I wanted to do quickly with 

 um um uh the information that have showed because this is kind of an interesting Maps and Hierarchies 

 use of both Maps plus hierarchies um so if I just create a flow here 

 quickly and select from that's 10 000 cities data sets 

 um so just from that uh sample data sets 10 000 cities that I can create a 

 snapshot here that looks at um let's do 

 we'll just do country um for now there's far more that you could do here 

 um and actually I'll put consonant too so we'll have uh country and consonants uh update that snapshot and so now if I 

 select that snapshots and add a map and actually place these dots on the map 

 so if I do this based on coordinates using map one and I'll 

 select latitude and longitude that will work 

 um but the one thing I neglected to do here and is sort of the the interesting 

 way to show this is that we can aggregate this latitude and longitude 

 um based on averaging so if I average these I inevitably find sort of the uh 

 the the center the geographic center um for the most further SMH cases um for 

 each of these and so what you can do is in this snapshot if I change this to a 

 color scheme based on hierarchy level um and just for this I'll also add in 

 some additional Dimensions height based on those hierarchy levels um and I'm going to invert it so three 

 one um so if I do 

 0.25 to zero this is the height off the map and I can 

 actually go in still to add in connections and add in based on 

 hierarchy level and I'll make the transparency of this more like 40. but Structures aggregating info 

 you can start to create these structures now which are aggregating information 

 and it's placing at a distance off the map based on something you're aggregating so the better thing to to 

 aggregate is something like population or something like that but now you're seeing the middle of each of them so 

 this is kind of one of those things where it's a combo of the two it's a both a hierarchy but it's also geospatial and I think that has a lot of 

 Promise as well for being able to show aggregations so still a lot more to 

 explore I think in aggregations as well as the ability to interact but um we'll be very curious to see if you guys have 

 other ideas on what you'd like to see that is sort of um somewhat relationship relational data 

 it's a little different than a graph database that's for sure um could you label that Center Point 

 that is the source of the hierarchy uh you can great question 

 um the um the only way to do that is to really add in a value that is a dummy value 

 um so if I go into this snapshot basically I need a something up on top Type in a Snapshot 

 here um and so I know this data set already and that I have something called type 

 which is balance sheet for every line and so if I put type balance sheet 

 that will actually now be the the top level and so now I'll see sort of a root node 

 in the very center now it's not quite accurate because this is adding the two together 

 which um doesn't really work but um anyways I just wanted to quickly show 

 you where you could do that so you can you could put labels on the countries 

 there at the top of those pyramids yes sir right yes yeah so labels here 

 definitely um yes 

 yeah that's powerful thanks um and so here I'm selecting country is the label but I actually only want to 

 label when it's when the column hierarchy level 

 is greater than or sorry is less than in this case three 

 because I don't want it to show up on the dot level but I do want it to show up here on the the country level 

 um and so um the other thing here is this is radial and I want it to basically 

 uh be further away 

 and that almost worked okay sorry I'm diving a little too deep into some more 

 experimental to your stuff but um but yeah I think that's an interesting sort of uh 

 use of hierarchies that is a little bit more emerging it's a pretty common use 

 case to label the highest level and maybe the second highest level in these 

 hierarchies and not label the details just because there's so many of them 

 all right what other questions do you guys have 

 okay I know it ran a bit over um so I appreciate you guys sticking on here 

 um I think the uh that was really awesome this was probably one of my favorite days to see you guys presents 

 uh those are really awesome um and yeah if you guys want to create some AR videos with those or anything like that 

 um I would be totally game to to do private sessions for you guys to to help record those or whatever 

 um I think that's awesome um so really inspiring to see and we're available here to help you homework is 

 very similar here um where it's basically you know find some hierarchy data well we can point you to this data sets or even you could 

 reuse the 10 000 cities like we just showed um but you know practicing there and you'll probably run into a few more 

 things to ask about I'd say um so I appreciate your sort of uh 

 uh kindness or understanding um while we we 

 still make some hierarchy updates Hey Mickey hey Michael I had one question do you 

 think next week we could cover how to potentially animate through data that 

 has a Time access yeah great Point let me take a note 

 yeah animation is a pretty important aspect um the really short answer is in today's 

 platform the way we do that is to create two steps first step and then second step and the first step you just apply 

 filters to the date and so it ripples in through that time and there's actually other 

 ways to do it too which we we might cover as well um but that's sort of the simplest way 

 and that the other thing to just quickly note because I I think is really powerful and use it a lot is 

 um in-step details you can control the amount of time it takes to go from one 

 step to another um and so um I'll just 

 you know just put this into random perhaps and turn off connections so if I 

 were to to do this as a movement to have dots then I could quickly change the 

 amount of time this takes you know if I make it like 30 seconds it's going to be way more dramatic and slower moving than 

 if I were to make it two seconds which is the default so just something to be 

 aware of and uh yeah know how you can sort of use that and there are some 

 other details within this just so you're aware there's a little animation Tab and there's some some details here for 

 ripple duration and item duration um yeah which we might get into uh it's 

 yeah might get into you but because uh last week in Bill's presentation he showed how the data dots splashed out to 

 the various regions of the map and I was like snagging so uh even if it doesn't happen 

 in the class I know it's capable of some really fascinating stuff like that so yeah we can get an idea about how to 

 inter interact with the timeline that would be a real uh yeah animation is one of my favorite 

 parts of the product actually for for dramatic presentation so that that will be fun to present that 

 next week all right uh other questions otherwise 

 Nikki I do want to give you the floor if you do want to present no I figured what I learned today about hierarchies would 

 help me with some problems I was having so I'm out okay perfectly content to present next time okay okay sounds good 

 then we'll do that um cool any other questions or comments 

 otherwise we will close up for the day I just have one comment that I end up uh closing out most of these sessions with 

 and that is if you are stuck or if you think there must be an easier way or a better way reach out to us with a 

 question we've got a lot of it a lot of tips we can that we can provide to you 

 so there's no such thing as a silly question in this in this in this space so we're happy to help 

 and to the question of getting getting this flow um this will actually a good way to uh 

 quickly uh point to one thing um so a few things in the share dialogue 

 there's a little button called share and you can create a public link so when 

 I click that button for uh creating a shareable link this you link is like a 

 public link I could send to anyone and they can get to this flow they can't change the flow but they can make a copy 

 of it if they want to use it used for their own or to remix basically you can 

 also share it privately where you can put someone's email or if you ever have a question for any of us you might be 

 familiar put in Michael at flow or Bill at flow or industry or Json app flow and 

 then it will be sent directly to us and then for some Enterprise accounts we have organizations and some other ways 

 to to share um but just sharing the ways you can share but the last thing I wanted to 

 show was Discovery so this is not used a ton yet but um we're hoping more will is that when 

 you click on publish for Discovery there is a tab on the Lister called Discovery 

 so if anyone wants to publish there you can't so you can take any of the flows 

 that you have created and publish for Discovery and then we can see them too 

 and uh we'll occasionally bring over some into the featured tab but that 

 mostly is Monitor or managed by us and the Discover tab is sort of open to everybody so you'll notice there is one 

 there called bound sheet from training and that is today so you can use that as sort of a a reference points or 

 um for learning on your own okay 

 great all right well thank you guys so much for your attention and amazing 

 presentations uh really exciting to see the progress and look forward to next week thanks everybody 

 bye-bye everybody thank you thank you thank you thank you bye thank you