How to graph utilization vs time in dashboard?

Question

question

Patrick Cloutier asked Nov 08 2021 at 6:33 PM Patrick Cloutier commented Apr 05 2022 at 3:05 PM

How to graph utilization vs time in dashboard?

Hello, I need to chart the utilization vs time of workers and processors on a dashboard. I was hoping for a simple State chart template like there is for other stats but there is none.

I have seen posts with hints of solutions but none propose a simple standard way of doing it were you can easily choose which objects you want like in a regular chart template.

It is a fairly standard requirement as the average utilization doesn't mean as much as the fluctuations over time.

I tried to do it in this sample model but it doesn't work yet.

1 - How can I reference the group of workers instead of just the worker?

2 - What else do I need to change to make it work?

I really think should be a standard chart template.

Thanks a lot,

UtilizationVStime.fsm

Software Version:

FlexSim 21.2.4

chart templates

utilizationvstime.fsm (607.4 KiB)

Answer 1 · 2021-11-08T19:45:22Z

Jordan Johnson answered Nov 08 2021 at 7:45 PM Patrick Cloutier commented Apr 05 2022 at 3:05 PM

Is this what you are looking for?

If so, here are the steps to create it:

Make a state table (you had already done that)
Make a Process Flow. The purpose of the process flow is to create one token per worker (in the group) per time interval. Each token will have a TrackedVariable. You'll listen to the state of each object, and when it changes, set your tracked variable to the same value.
Get the utilization for the TrackedVariable from the state table.
At the end of the time interval, log the time, worker, and utilization in the stats collector
Make a chart

Here's the model, so you can investigate these steps:

utilizationvstime_1.fsm

Adding a removing objects from the group will add or remove them in the chart. The ProcessFlow Variable called Interval determines how often the utilization is recorded.

This reason for all these steps is that you have to "forget" about the time spent in any state in previous time intervals.

If you confirm that this chart is what you want, I can add a request to the dev list.

1636400384017.png (45.7 KiB)

utilizationvstime-1.fsm (46.7 KiB)

· 8

Patrick Cloutier commented · Apr 05 2022 at 1:27 PM

Hello Jordan, this works awesomely great for operators and I'm using it right now in a case where I have 2 cranes and I measure their hourly utilization. It works great but I don't understand how it works.

And I'm trying to also plot the total utilization of both cranes. How could I tweak to process flow or the stats collector to also show the total utilization of both cranes?

On the same graph I'd have: crane1, crane2, total of both. Or it could be 2 different graphs if its easier.

I could export the current graph data to csv, make a pivot table and chart it in Excel but I was wondering if it can easily be done directly in FlexSim.

Thanks a lot,

1 ·

Jordan Johnson ♦♦ Patrick Cloutier commented · Apr 05 2022 at 2:56 PM

I will write an answer for your questions, but please post this comment as a new question, and include a link back to this question.

0 ·

Patrick Cloutier Jordan Johnson ♦♦ commented · Apr 05 2022 at 3:05 PM

Done, but I didn't know how to insert this into the question: @Jordan Johnson

0 ·

Patrick Cloutier commented · Nov 08 2021 at 8:27 PM

Jordan, the link to the model gives me a HTTP Status 404 - Not found error

0 ·

Jordan Johnson ♦♦ Patrick Cloutier commented · Nov 08 2021 at 8:59 PM

I reposted it, see if it works now.

0 ·

Patrick Cloutier Jordan Johnson ♦♦ commented · Nov 23 2021 at 9:17 PM

Jordan, I applied this to my model and it works great but I realize that for this to be useful you need to be able to "Y Split by" as I did. See photo. Otherwise it would just be a jumble of lines because everyone fluctuates between 0 à 100%.

Thanks a lot !

0 ·

screenshot-2021-11-23-161625.png (95.4 KiB)

Patrick Cloutier commented · Nov 10 2021 at 3:22 PM

Yes it is what I'm looking for ! I really think it should be a Chart Template.

But it doesn't work if I add a Processor to the Group. I haven't analyzed the ProcessFlow to see why and I will but if it's going to become a Chart Template, it should be flexible enough to chart Processors as well as Operators utilization.

Thanks a lot,

0 ·

Jordan Johnson ♦♦ Patrick Cloutier commented · Nov 10 2021 at 5:28 PM

Adding a Processor worked fine for me in the model I posted, although the Processor's utilization matched Operator's utilization almost exactly. The overlapping line makes it hard to see.

0 ·

question