Versions Compared

Key

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

...

In this guide, you’ll learn how to toggle time intervals (Days, Months, Years) on the same widget, like this:

...

Managing Time Intervals.mp4

Let’s start by building out a line chart, and then we’ll add in the time-switching capabilities.

...

This works when you want to analyze a couple weeks or a single month. But what if you want to trend the last 6 months? Or the last 2 years?

Let’s work through this together.First, name this line chart “Production Trend” like in the screenshot below.(this step is important for the next section. You can name it anything you want, just make sure it’s easy to remember!):

...

Add a Dimension-Changer and Configure it to your Line Chart

...

Right-click again, and Duplicate a second time (you should have 3 identical measures now).

...

5.

Open the widget dropdown menu and select

Line Chart. For your X-Axis, Add and select “Calendar DateTime

...

In the same widget panel, click Add in your Widget Filters panel.

...

...

Search and select “ReasonState Name

...

De-select every item here, and then search for and select a single Reason that you really care about (in this example, we will use “Changeover”).

...

Image Removed

...

Add a Trendline

Let’s finish with a Linear Regression to determine if your Changeover durations are getting longer or shorter over the course of time.

  1. Right-click on “Total Scheduled Hours” and select Duplicate.

    Image Removed

  2. For this duplicated measure, Right-click it and select Regression → Linear

    Image Removed

...

Click Apply to save your widget to your dashboard.

...

. Click the “Y” icon on the second measure, and change it to Months.

...

6. Do the same with the third measure, except this time, select Days.

...

Your screen should now look like this:

...

Connect the Dimension-Changer with your Line Chart

On the right-side of your Dimension-Changer is a “Design” tab.

  1. Click Add + and then select the name of the trend chart (“Good Production Trend”) that you made earlier.

    Image Added


    2. In the Dimension Index, set it to “0”, and in the Panel to Change, type “X-Axis” (case-sensitive).

    Image Added

    3. Click “Apply” to save your changes

Your dashboard should have a horizontal tab that shows the time interval toggles you just made.

...

Congratulations! 🙌 🎉 You made a dynamic time changer!

Click through each of these items to change the time intervals of your widget.

Filter by label (Content by label)
kb-how-to-article
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@91fa3f99showSpacefalse
sortmodified
typeshowSpacepagefalse
reversetruelabels
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "SLXDOC"
labelskb-how-to-article
Page Properties
hiddentrue

Related issues