Training 3 Transcript
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
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
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
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
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