question

Tee Hiett avatar image
0 Likes"
Tee Hiett asked tannerp commented

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

FlexSim 20.1.0
flexsim 20.1.0data collectorprocess flow chart
tutorial-1-3.fsm (150.6 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

tannerp avatar image
0 Likes"
tannerp answered tannerp commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

tannerp avatar image tannerp commented ·

@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 Likes 0 ·
box-plot-wait-times.png (38.7 KiB)
tee-stats-help-4.fsm (128.5 KiB)
Tee Hiett avatar image Tee Hiett tannerp commented ·

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 Like 1 ·
tee-stats-help-3a.fsm (127.7 KiB)
Tee Hiett avatar image Tee Hiett tannerp commented ·

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 Likes 0 ·
tannerp avatar image tannerp Tee Hiett commented ·

@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 Likes 0 ·
hangup-custom-code.png (64.6 KiB)
Show more comments