Power BI Builds 18 - OEE Manufacturing Report

Challenges OEE Manufacturing Report
82

Updated with a new tab ‘try Deneb’ and now the visual supports zoom, pan and tooltips. This is much more useful as you can zoom into an interval and explore the outages, etc.

image
image841×331 16.8 KB

Use the mouse wheel to zoom in and pan around.

Started with the empty Deneb specification and built it up to:

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",	
  "description": "An attempt at a chart recorder -like output",
  "data": {"name": "dataset"},
    "params": [{
    "name": "grid",
    "select": "interval",
    "bind": "scales"
  }],
  "mark": {
    "type": "bar"
  },
  "encoding": {
    "y": {
      "field": "Severity",
      "type": "ordinal",
	  "sort": ["Minor", "Major", "Working"]
    },
    "x": {
      "timeunit": "day",
      "field": "Start",
      "type": "temporal",
      "title": "Day and Hour",
      "axis": {
        "labelAngle": -45
        }
      },
    "x2": {
      "field": "End",
      "type": "temporal"
    },
    "color": {
      "field": "Severity",
      "type": "ordinal",
      "scale": {
        "domain": ["Working", "Major", "Minor"],
        "range": ["#00FF00", "#FF0000", "#FFA500"]
        }
      },
    "opacity": {
      "condition": {
        "test": {
          "field": "__selected__",
          "equal": "off"
        },
        "value": 0.3
      },
      "value": 1
    },
    "tooltip": [
      {"field": "Start", "type": "temporal", "timeUnit": "hoursminutes"},
      {"field": "Duration", "type": "quantitative"},
      {"field": "OEE Category", "type": "nominal"},
      {"field": "newTotalMade", "type": "nominal"},
      {"field": "newGood", "type": "nominal"}
      ]
  }
}

Likely a bit clumsy and need to rename some items, improve the tool tip, etc.
StripChart v2.pbix (2.1 MB)

Tim

83

Another way to pan and zoom is shown below. Select a region on the lower visual to highlight in the visual above - where tooltips provide additional detail on production and outages.

image
image852×451 26.3 KB

Tim
StripChart v2b.pbix (2.1 MB)

84

Tim, great idea to display the stoppage data on a strip chart!
I noticed in your deneb visual the following json validation issue. Are these showing in your visual as well?
image

85

Thanks, Daran and yes I have all those errors. Likely an artifact of pasting a bunch of code fragments together - and I did not look a lot at the Config section - where I likely need to delete things I override in the specification.

I like this Deneb stuff - but have a lot to learn.

tim

1 Like
86

Playing with this a bit more, the schema validation errors appears when I add the “x2” definition for the end of the bar. Using the GANTT example the error appears when I define the x axis as temporal. It may be that I need to use a DUR to define the bar size (instead of start and end time)

I added these two examples to the example template tab.
StripChart v2c.pbix (2.1 MB)

1 Like
87
1 Like
88

Congratulations @Paul.Gerber

Paul Gerber - Winner
Paul Gerber - Winner1280×905 113 KB

4 Likes
89

Very nice report!
@EnterpriseDNA @Rachwen_Mesbehi entry zip file on the showcase is missing the pbix file:
OEE Data Report | Enterprise DNA

Please add the pbix file so we can all learn from this great report!
Thanks

90

Hello @Paul.Gerber @haroonali1000 Please share the pbix file to konw more about dashboard. Thanks in advance and please consider it on urgent basis

91

Hi @V_Baisla,

Welcome to the forum.

More about data and requirements you can find at the brief.

If you are look for some showcases - you can find at : https://app.enterprisedna.co/app/showcase

Hope it helps.

1 Like
92

Hi @V_Baisla people on this forum, by in large, volunteer in their free time so please don’t put time pressures on contributors, it is against the ethos of the forum.

1 Like