Charts are a great way to visualize information. They let you arrange data in
meaningful ways, allow you to tell a story, and can really catch the reader's
eye. But when dealing with large datasets, visualizing all the data at once can
be somewhere between a tough to impossible mission. You usually need to filter
the data and concentrate on a specific part that is of interest, and then when
you want to see a different part of the data you'll need to filter it again and
refresh the view. That's why we're happy to announce the introduction of
dashboards in Apps Script, which allow you to compose multiple charts and
filters into a single experience!
What is a dashboard?
Dashboards in Apps Script Deploy as web app "
option. They are perfect for creating interactive reports, where users can gain
extra insight through exploring the data.
Creating a simple dashboard UI Application example
dashboard
where a category picker and a range slider are used to drive the data visualized
by a pie chart and a table chart.
Note that a dashboard is an interactive entity. Playing with its controls will
change the charts in real time. You can see exactly how this dashboard was
created, and learn more about how to build dashboards in general, by reading
through our new Building a Charts
Dashboard
tutorial .
Going further
VIDEO
To conclude, dashboards are powerful gadgets that allow you to handle and get
valuable insights on complex datasets. Now made easy to build in Apps Script,
try it on your data.
Roee Eilat profile
3 comments :
There is an error in one of the links, it should be:
Building a Charts Dashboard tutorial.
Good catch! This should be fixed now.
Great Vid! one quick question, Can I create two dashboards within the same application pulling data from a spreadsheet on one dashboard and from a pivot table on a second one? The problem I am running into is that when you edit the filters on one dashboard the graph on the other dashboard become invisible.
Thank you.
Post a Comment