Adding the other Visualizations

    All the remaining visualizations in the dashboards will use the same sample spreadsheet.

    Note

    If you want to change your data source, you will need to select the overflow button next to the data source name or create a new data source instead. You can also duplicate visualizations to speed up the creation process.

    This section will cover the following visualizations:

    ThumbnailSISStockValue All

    Silver Security Stock Value 2018

    ThumbnailSISNYSEBATS All

    GLB Fiscal (Monthly) NYSE + BATS

    ThumbnailForecast All

    Forecast (Chg, Bid & Offers) - 2018 to 2023

    ThumbnailStockVariation All

    Stock Variations

    ThumbnailStockVolumes All

    Stock Volumes

    Silver Security Stock Value 2018

    The SIS Stock Value 2018 visualization displays the average value for the Soylent Corp stock during 2018 in a text gauge. In this case, you can duplicate the first visualization created during the first steps, as all that will change is the selected filter.

    1. Open the overflow button in the "Globex Stock Value 2018" visualization, and then select Duplicate.

      DuplicatingVisualizationSISStockValue\_All

    2. Rename the visualization by opening its overflow button and selecting Rename.

      DuplicateVisualizationRenaming\_All

      Set the value to "Silver Security Stock Value 2018"

      SISStockRenamingVisualization\_All

    3. Enter Edit Mode by selecting the overflow button again and selecting Edit.

      SISStockValueEditingVisualization\_All

    4. This visualization displays the stock value for Silver Security Corp, as it is the second highest stock value. Because we choose to duplicate the visualization, the number you are seeing in the text gauge corresponds to Globex. In order to change it, select the Stocks field in Data Filters. Then, change the Selected Value to Silver Security Corp and unselect Globex.

      Updating the filter in Analytics

      Then, select Update Filter.

      Once you are done, go back to the Dashboard Editor by selecting the tick icon in the top right-hand corner.

    GLB Fiscal (Monthly) NYSE + BATS

    The GLB Fiscal visualization displays the price movements for the Globex stock during 2018 considering both the New York Stock Exchange (NYSE) and the Better Alternative Trading System (BATS) values in a Candlestick Chart. In order to create it:

    1. Select the + button in the right corner of your dashboard, and select the Finance Dashboard sheet in the Analytics_Dashboard_Tutorials spreadsheet. Then, select Load Data.

      Loading data in Analytics

    2. Open the visualizations picker by selecting the grid icon in the top bar, and select the "Candlestick" chart.

      Selecting the Candlestick chart in Analytics

    3. In the Data Editor, drag and drop the Date field into the Label placeholder of the data editor, Open into Open, High into High, Low into Low and Close into Close.

      Dragging and dropping fields in Analytics

    4. By default, the Date information in Label will be displayed in years. In order to change this, select Date in the Label placeholder of the data editor, and change the Date Aggregation to Day.

      Changing date aggregation in Analytics

      Then, select Update Field.

    5. If needed, you can remove the fraction digits in the Y axis by selecting the values in Open, High, Low and Close, and changing Fraction Digits to 0.

      Removing fraction digits in Analytics

      Then, select Update Field.

    6. The visualization displays the GLB stock value, so you will need to introduce a filter for Stocks in order to display that particular option. Drag and drop Stocks into Data Filters and then choose Select Values.

      Selecting Filters in Analytics

      There, uncheck all options and select only Globex.

      Working with filters in Analytics

      Then, select Create Filter.

    7. You will also need to introduce a filter in order to display information only for 2018. To do this, drag and drop Date into the Data Filters placeholder of the data editor and, under Filter Type, select Filter by Rule.

      Filtering by rule in Analytics

      Select the Custom Date Range rule and enter January 1st through December 31st.

      Selecting a custom date range in Analytics

      Then, select Create Filter.

    8. Change the title of your visualization to "GLB Fiscal (Monthly) NYSE + BATS" by selecting the pencil icon next to "Finance Dashboard".

      Once you are done, go back to the Dashboard Editor by selecting the tick icon in the top right-hand corner.

    Forecast (Chg, Bid & Offers) - 2018 to 2023

    The Forecast visualization displays the changes, bids and offers for all stocks for a 5 year period in a line chart. In order to create it:

    1. Select the + button in the right corner of your dashboard, and select the Finance Dashboard sheet in the Analytics_Dashboard_Tutorials spreadsheet. Then, select Load Data.

      Loading data in Analytics

    2. Open the visualizations picker by selecting the grid icon in the top bar, and select the "Line" chart.

      Selecting the Line chart in Analytics

    3. In the Data Editor, drag and drop the Date field into Label, Stocks into the Add Hierarchy section of Label, and Change, Bid and Offer into Values.

      Dragging and dropping fields in Analytics

    4. By default, the Date information in Label will be displayed in years. In order to change this, select Date in the Label placeholder of the data editor, and change the Date Aggregation to Month.

      Changing date aggregation in Analytics

      Then, select Update Field.

    5. To remove the fraction digits in the Y axis, select the fields in Values, and change Fraction Digits to 0.

      Removing fraction digits in Analytics

      Then, select Update Field.

    6. Change the title of your visualization to "Forecast (Chg, Bid & Offers) - 2018 to 2023" by selecting the pencil icon next to "Finance Dashboard".

      Once you are done, go back to the Dashboard Editor by selecting the tick icon in the top right-hand corner.

    Stock Variations

    The Stock Variations visualization displays the change in stock offers for a 12 month period in a sparkline chart. In order to create it:

    1. Select the + button in the right corner of your dashboard, and select the Finance Dashboard sheet in the Analytics_Dashboard_Tutorials spreadsheet. Then, select Load Data.

      Loading data in Analytics

    2. Open the visualizations picker by selecting the grid icon in the top bar, and select the "Sparkline" chart.

      Selecting the sparkline chart in Analytics

    3. In the Data Editor, drag and drop the Date field into Date, the Offer field into Value and Stocks into Category.

      Dragging and dropping fields in Analytics

    4. By default, the Offer field will be displayed as a number. In order to display it as currency, select it in the data editor and change Type to Currency.

      Changing the formatting type in Analytics

      Then, select Update Field

    5. The Last 12 Months chart will be displayed using a Line Chart by default. In order to match the sample, let's set it to display an area chart instead. Go to the Settings menu of the Visualizations Editor, open the Chart Type dropdown, and select Area.

      Selecting the Area chart type in Analytics

    6. Change the title of your visualization to "Stock Variations" by selecting the pencil icon next to "Finance Dashboard".

    Once you are done, go back to the Dashboard Editor by selecting the tick icon in the top right-hand corner.

    Stock Volumes

    The Stock Volumes visualization displays the amount of stocks available during a one year period in a line gauge. In order to create it:

    1. Select the + button in the right corner of your dashboard, and select the Finance Dashboard sheet in the Analytics_Dashboard_Tutorials spreadsheet. Then, select Load Data.

      Loading data in Analytics

    2. Open the visualizations picker by selecting the grid icon in the top bar, and select the "Sparkline" chart.

      Selecting the linear gauge in Analytics

    3. In the Data Editor, drag and drop the Stocks field into Label and the Volume field into the Values placeholder of the data editor.

      Dragging and dropping fields in Analytics

    4. You will also need to introduce a filter in order to display information only for 2018. To do this, drag and drop Date into the Data Filters placeholder of the data editor and, under Filter Type, select Filter by Rule.

      Filtering by rule in Analytics

      Select the Custom Date Range rule and enter January 1st through December 31st.

      Enter custom date range in Analytics

      Then, select Create Filter.

    5. Change the title of your visualization to "Stock Volumes" by selecting the pencil icon next to "Finance Dashboard".

      Once you are done, go back to the Dashboard Editor by selecting the tick icon in the top right-hand corner.