Versions Compared

Old Version 24

changes.mady.by.user Chellie Esters

Saved on

compared with

New Version 25

changes.mady.by.user Chellie Esters

Saved on

Key

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

Image Modified

Telling Your (Data) Story

Storytellers usually design and select characters who have the right level of depth and complexity needed to further a story. Similar to storytellers, both data scientists and visualization experts interpret data —their "characters" — to help them answer questions and relay the right information.

Before creating your first visualization, you want to identify the questions you need to answer using data. Then, use the data fields in Analytics to find the data — or the "characters" — needed to help you answer those questions. 

In Analytics, the characters are called Dimensions and Measures. 

About Dimensions and Measures

Dimensions and Measures are types of preexisting data fields used to build visualizations.

  • A Dimension can be thought of as a group or bucket of data.
  • A Measure is information about that bucket of data.
Info
iconfalse
titleA Simplified Example on How Dimensions and Measures Work (Especially for Non-Data Scientists)

Status
colourYellow
titleScenario

In a refrigerator, you see an array of food: fruits, vegetables, and cookies (or biscuits in British English). These food groups can be thought of as Dimensions because they are individual groups of data.

Now, let's say you want to know exactly what fruits, vegetables, or cookies there are in this refrigerator. You could ask the following questions:

  • How many pieces of fruit are in this refrigerator?
  • How much of that fruit are bananas?
  • How many pieces of fruit and vegetables are green? (Naturally green, of course, not molded or otherwise bad!)
  • Are there more cookies (or biscuits) than fruit and vegetables?
  • Are there more chocolate cookies (or biscuits) than lemon ones?
  • Are there more lemon cookies (or biscuits) than actual lemons? 

These questions could be thought of as Measures because you are seeking information about one type of food against itself and/or each other.

Now, let's take a look at how Dimensions and Measures work in Analytics.

Viewing Dimensions and Measures in an Explore

Let's say that you want to know how many work orders are in different work order statuses. In this scenario:

  • the Dimension is the Work Order Status: Open, In Progress, Completed, Invoiced (much like fruits, vegetables, and cookies).
  • the Measure is the information you want to know about the work order statuses — in this case, the number of work orders (or Work Order Count). Questions such as "How many work orders are in the Open or In Progress status?" or "How many work orders are not yet Invoiced?" can be answered using this Dimension.
Section


Column
width35%


Column
width65%

When selecting a Dimension or Measure you can do the following:

  1. Click a data field to activate it.
    • Notice on the left that WO Status is activated because the background is white, however, WO Count is not yet activated.
    • Activated data fields appear in the Data area.
  2. Hover over a data field and click Filter or Pivot to activate these abilities with your data using that data field.
  3. Hover a field and click the Gear icon to use that Dimension as a Measure data point.
    • For example, the WO Status Dimension gives you a list of work order statuses, but when you click the gear and select Count, you will retrieve the number of statuses.


Anchor
anly-examplefollow
anly-examplefollow
Example: Selecting Data

Over the next few pages, we will follow an example of building a story using data. We start with a simple scenario and then build in more complexity as we move through the workflow. Follow along with your data, noting that your data will be different from what is shown.

Info
iconfalse
titleExample: Selecting WO Status and WO Count

Status
subtletrue
colourBlue
titleExample

In this example, we want to see the number of work orders in each status. It will look like this:

Image Removed

  • In the Workorders Explore, expand the *Workorders list.
  • Click the Dimension WO Status.
    1. Make sure to click the word WO Status, not Pivot or Filter.
    • Click the Measure WO Count.Make sure to click the word WO Count, not Pivot or Filter

    .


  • Click Run on the top-right of the page. You will see the data for those data points listed.

    • Image Removed

    Info

    Most visualizations have at least one Dimension and one Measure.


    Next section: Checking Out the Data

    Now that you understand what Dimensions and Measures are and have seen what they look like when selected, let's dig a little deeper into the data.

    Live Search
    spaceKeySCU
    additionalpage excerpt
    placeholderSearch our Knowledge Base
    typepage

    Panel
    titleColor#ffffff
    titleBGColor#5fa7d0
    borderStylegroove
    titleIn this Article

    Table of Contents
    maxLevel3
    minLevel2
    indent20px

    Panel
    titleColorwhite
    titleBGColor#75a346
    titleRelated Articles

    Filter by label (Content by label)
    showLabelsfalse
    max8
    showSpacefalse
    sorttitle
    cqllabel in ( "enhancedanalytics" , "analytics" , "dimensions" , "measures" , "explore" ) and space = currentSpace ( )


    Tip
    iconfalse
    titleExample: Selecting WO Status and WO Count

    Status
    subtletrue
    colourBlue
    titleExample

    Info
    iconfalse
    titleExample: Selecting WO Status and WO Count


    In this example, we want to see the number of work orders in each status. It will look like this:

    Image Added

    1. In the Workorders Explore, expand the *Workorders list.
    2. Click the Dimension WO Status.
      1. Make sure to click the word WO Status, not Pivot or Filter.
    3. Click the Measure WO Count.
      1. Make sure to click the word WO Count, not Pivot or Filter.
    4. Click Run on the top-right of the page. You will see the data for those data points listed.

    Image Added

    In this example, we want to see the number of work orders in each status. It will look like this:

    Image Added

    1. In the Workorders Explore, expand the *Workorders list.
    2. Click the Dimension WO Status.
      1. Make sure to click the word WO Status, not Pivot or Filter.
    3. Click the Measure WO Count.
      1. Make sure to click the word WO Count, not Pivot or Filter.
    4. Click Run on the top-right of the page. You will see the data for those data points listed.

    Image Added