How do build Process Flow Charts in this tutorial model?

Question

question

Tee Hiett asked Apr 21, '20 tannerp commented May 4, '20

How do build Process Flow Charts in this tutorial model?

Tutorial 1_3.fsm

It the Attached Process Flow model, I would like to add 3 metrics to the dashboard:

The number of Number of wait calls/ The number of total calls
the number of hang-up calls/the number of total calls
removing the 0-wait calls And the Hang-up calls, I would like a box plot of the waiting minutes for the Calls that actually had to wait.

Thanks for your help.

Tee

Software Version:

FlexSim 20.1.0

flexsim 20.1.0 data collector process flow chart

tutorial-1-3.fsm (150.6 KiB)

Answer 1 · 2020-04-23T20:30:31Z

tannerp answered Apr 23, '20 tannerp commented May 4, '20

Hi @Tee Hiett,

Just to make sure I'm understanding the metrics correctly, I wanted to clarify a couple things:

1) "Wait calls" are any tokens that have to wait > 0 seconds at the Acquire Service activity AND end up receiving service.

2) "Hang-up calls" are any tokens that wait > 0 seconds at the Acquire Service activity AND do not receive service.

3) The total number of hang-up calls is equal to the throughput of the Unhappy Customers Sink.

If these are true, then we can easily get the total number of calls and the number of hang-up calls. We just need to get the number of wait calls. These would be any tokens that had a Staytime > 0 at the Acquire Service activity, correct?

I created a Calculated Table for some of these metrics, and I've got a Stats Collector that will collect the data you need on Wait Time at the Acquire Service activity. Let me know if I'm on the right track.

tee stats help_2.fsm

wait-time-and-call-count.png (9.3 KiB)

tee-stats-help-2.fsm (109.8 KiB)

· 13

tannerp commented · Apr 23, 2020 at 08:51 PM

@Tee Hiett,

Took me awhile, but I figured out how to get the box plot as well, which takes the calls that did not hang up AND had to wait > 0 seconds and plots the wait times. I used a Calculated Table and a SQL query that pulls tokens that had to wait and did not hang up. Hopefully this helps!

tee stats help_4.fsm

0 ·

box-plot-wait-times.png (38.7 KiB)

tee-stats-help-4.fsm (128.5 KiB)

Tee Hiett tannerp commented · Apr 23, 2020 at 09:26 PM

While you were working on the model, so was I, I made a few changes and describe my approach which seems to fit in well with what you were doing. I look forward to studying your latest version tomorrow. I will get back to you.

Thanks again

Tee

--------------

Yes, you are on the right track. I made a couple of changes in the model that you sent me which may get us further along in the process. BTW, I've already learned a lot from your model.

I assigned the value of 0 to the label "HungUp" which is changed to a 1 when the customer leaves and becomes an unhappy customer. I put the delay activity in the model just so I could check to make sure that patient does get a 1. If now we can get the value of the label "HungUp" into the wait time table, we should have everything we need to complete the Calculated Tables. I have been trying to do this but I cannot figure out how to get the value of "HungUp" included with each record. I look forward to seeing how to do that.

Also I am not familiar with the Calculated Tables and I'm looking forward to getting the raw data s into that table and then. I also look forward to using these tables.

Thanks so much for your help.

Teetee-stats-help-3a.fsm

1 ·

tee-stats-help-3a.fsm (127.7 KiB)

Tee Hiett tannerp commented · Apr 26, 2020 at 10:53 PM

Thanks, @tanner.p

I do have one question and one request. Where in the flowchart is the value of the label Hangup set to one?

The request is for help with getting the data in the CallsByType changed into one row with the added field with the value of Unhappy Calls/ ( Unhappy Calls + Happy Calls).

Thanks for your help with this

Tee

0 ·

tannerp Tee Hiett commented · Apr 27, 2020 at 02:16 PM

@Tee Hiett,

The Hangup label is set using Custom Code in the Stats Collector as shown below. I tried a number of options and this seemed to be what worked best for me.

I also was hoping to put the column you mentioned in the CallsByType table, but I couldn't quite get it the other day. I'll give it another go today and let you know what I come up with.

0 ·

hangup-custom-code.png (64.6 KiB)

Show more comments

question