...
In this guide, you’ll learn how to toggle time interval size intervals (Days, Months, Years) on the same widget.
For example:
You want to measure {Good Production} over the course of the last 14 days
After reviewing the results, you want to quickly check your good production trend over the last 3 months
...
There are many ways you can accomplish this. Each method has its own drawbacks:
You can create 2 identical line charts, except you set the first chart to DAYS as a time interval, and the second chart to MONTHS as its interval
You can duplicate multiple
In this case, you’d want your X-Axis (horizontal line) to be in Days.
But no
get comfortable with the interface, learn the basics of creating a new dashboard, add real widgets and charts, and learn how to find meaningful insights with downtime data!
You can accomplish this in several ways:
, like this:
...
Let’s start by building out a line chart, and then we’ll add in the time-switching capabilities.
Create a Line Chart with a Time Dimension
...
| Info |
|---|
Note: We are using demo data for this tutorial, which is why our screenshot above has a strange spike in it. |
🕵️ If you look closely at your line chart, you’ll notice that the horizontal line (x-axis) is in Day intervals.
...
This works when you want to analyze a couple weeks or even up to a single month. But what if you want to trend the last 6 months? Or the last 2 years?
In this case, our trend chart might be better if its horizontal line (x-axis) uses Month intervals.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
Next, we’ll We’ll need to create the ability to quick toggle between time intervals.
...
Next, we will duplicate “Calendar DateTime” so that we have different intervals (Year, Month, Day) to toggle.
Create Time Interval Toggles (Day, Month, Year)
4. In the same screen, right-click on “Years in Calendar DateTime“ and select Duplicate
...
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”).
...
...
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.
Right-click on “Total Scheduled Hours” and select Duplicate.
For this duplicated measure, Right-click it and select Regression → Linear
...
Click Apply to save your widget to your dashboard.
...
.
Right-click again, and Duplicate a second time (you should have 3 identical measures now).
...
5. 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.
Click Add + and then select the name of the trend chart (“Good Production Trend”) that you made earlier.
2. In the Dimension Index, set it to “0”, and in the Panel to Change, type “X-Axis” (case-sensitive).
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.
Related articles
| Filter by label (Content by label) | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|