Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

3. Compiling the Dashboard

Now that all three looks are complete, they need to be combined into a central location so that all 3 queries can be run and viewed simultaneously. This is what dashboards are built to do. 
To create a new dashboard:

  • Browse to your personal space, if not already there
  • Open one of the looks that were just created
  • Click the Settings icon in the top right corner of the look
    Image Added
  • Click on Add to Dashboard
    Image Added

  • Because we are creating a NEW dashboard, click on New Dashboard
    Image Added
    *If this look was being added to an existing dashboard, select the desired dashboard from the space by clicking its name, and then click Add

    Image Added
  • Type a name for the dashboard and click OK
    Image Added
    The new dashboard will now appear highlighted in the dropdown list and the message at the top of the pop-up will reflect the visualization type of the look that was just added.

    nicubunu-Light-bulb-300px.pngImage Added
    Another way of adding a look to a dashboard is to refer to the right-hand side of the screen when inside the look:
    Image Added
    Add to Dashboard can also be clicked here and the steps are the same as above.

  • Add the other two looks by using one of the methods above.
  • Browse to your personal space and click the new dashboard containing the three looks that you just added
    • By default, the looks will be stacked vertically, in the order they were added



Edit the default layout of the dashboard:

  • Click Edit in the top right
    Image Added
  • Resize looks by hovering your mouse in the bottom right corner of the look, then clicking and dragging it to make the tile larger or smaller
    Image Added
  • Change the positioning of looks by hovering your mouse in the top left corner of the look, then clicking and dragging the tile up or down
    Image Added

  • While in Edit mode, you can also do the following:
    Image Added
    • Looks: view a list of all your individual looks. 
      Any that are contained within this dashboard will have the Remove option to take them out of the dashboard:
      Image Added
      And the rest will display an +Add option:
      Image Added

    • Text: Any text added in this pop-up will display in its own tile at the bottom of the dashboard:
      Image Added

      • Any text typed into the Body can be formatted using the markdown toolbar. This gives you the option to add:
        Image Added
        • Image Added Bold text
        • Image Added  Italicized text
        • Image Added Quoted text
        • Image Added  HTML code
        • Image Added Clickable link to another report
        • Image Added Bulleted list
        • Image Added Numbered list

      • Click Save to view your formatted text in the dashboard
        Image Added

    • Filters: Add or Edit any of the filters on the individual looks contained in the dashboard. Any change made here will be reflected on the individual look and vice versa.
      Image Added

    • Settings: Modify selected options on the dashboard
      Image Added
      • Run on Load: [defaulted ON] The dashboard will perform a database query once at load time

        Image Added
        This setting is turned OFF on all LookML dashboards. Doing so provides the user with a Run button on the top left of the dashboard so that they can choose when to perform the database query.
        Image Added
      • Dashboard Auto Refresh: when enabled, the user can use the dropdowns to select the timing at which to refresh the data.
        Image Added
      • Auto Refresh can also be set on the Dashboard Element Name

  • Once you are happy with the arrangement, click Done Editing in the top right
    Image Added



 4. Scheduling

Setting a schedule for any report is optional; however, it is the best option if you would like to keep the saved dashboard in your personal space and still share the data with others.
Once you have a list of recipients, and an idea of the settings you would like for the report (when to send, how often, etc) the steps outlined in this article will walk you through the process.