Production Dashboard

Production Dashboard

An example of an interactive dashboard that lets you view the performance of your production stations

Purpose

The purpose of this application is to provide an overview of your Production cells, allowing you to select individual cells to review and evaluate the details of their performance.

Video Overview

How it Works

This application relies on production data that is being generated by other applications in the library using a shared table structure. The application that best demonstrates this shared structure is the Production Logging Module though many other applications in the library use similar methods to record performance.

When the App is first opened, it stores the current date and uses that to filter the analytics. Clicking on the blue time filter buttons will change that variable and display data from different date ranges.

Clicking on a specific station, on the left, will further filter the data such that you can drill down into the stations you are interested in.

Installation

This application relies on a number of analytics in order to function. These will not be downloaded along with the application, however the tables and their structures will. You will need to create these 5 analytics (or choose ones of your own!). For each analytic, click on the "select from existing" button, then select the "Status history" table as your data source

Finally, click on "create new analysis" to begin making your analytic. You will need to do this for each of the following analytics.

Output

Defects

Yield

(you can copy and paste the expression here)
round((sum(@*Status History Actual Output ) / (sum(@*Status History Actual Output ) + sum(link(@*Status History Defects , 0)))) * 100, 1) + '%'

Status Each Hour
x-axis expression:
format_date_tz(date_trunc(@*Status History Time End , 'hour'), 'MM/DD hh A', 'America/New_york')

Compare by expression:

link(@*Status History Status , 'NO STATUS')

Output Over Time

x-axis expression:
format_date_tz(date_trunc(@*Status History Time End , 'hour'), 'MM/DD hh A', 'America/New_york')