topic Re: Is it possible to create a custom chart in the dashboard? in FlexSim Forum

Is it possible to create a custom chart in the dashboard?

an_lam2 — Mon, 24 Jul 2023 03:21:03 GMT

[ FlexSim 19.2.4 ]

Hi, I need help on the following, is it possible to create a custom chart in the dashboard using the following formula below?

Define the variables:

1. LC (Labour count is a constant given number)
2. Standard Efficiency divider = 233
3. Actual Manpower (Number of operators in the model)
4. Production Hour (Simulation time/hour)
5. Output (where output of the end queue)

Formula:

Ideal Time = LC * 233 / Output

Actual Production Hour = Actual Manpower * Production Hour

In the dashboard, calculate:

Efficiency = Ideal Time / Actual Production Hour

Example:

LC = 1.3

Standard Eff Divider = 233

Actual Manpower = 2

production hour = 1 hour

Output = 292 pieces

Ideal Time = 1.3 * 233 / 292 = 1.037

Actual Production Hour = 2 * 1 = 2

Efficiency = Ideal Time / Actual Production Hour = 1.037/2 = 0.518 or 51.8%

Custom Dashboard.fsm

Re: Is it possible to create a custom chart in the dashboard?

joerg_vogel_HsH — Mon, 24 Jul 2023 04:25:58 GMT

@An L2, yes, it is possible. Please do some of the tutorials about advanced techniques gathering data. If I would do this, I'd start with a standard ouput statistic collector, a calculated table and a dashboard with a pie chart.

Re: Is it possible to create a custom chart in the dashboard?

an_lam2 — Thu, 27 Jul 2023 07:10:28 GMT

@Joerg Vogel Thanks for the tip, I have tried to study your suggestion, currently I can calculate for Ideal Time base on the formula I have given in the post, but I'm still lost on how to do this custom chart.

Custom Dashboard.fsm

Your browser does not support HTML5 video.

Re: Is it possible to create a custom chart in the dashboard?

moehlmann_fe — Thu, 27 Jul 2023 11:48:05 GMT

It looks like all you have to do is divide that value by the current model time (in hours). You can do that directly in the Calculated Table with a custom expression metric.

Then add a base chart of your chosen type and choose the Calculated Table as data source.

Though I have some doubts whether your formula is correct. Why would the efficiency drop if the output goes up?

Re: Is it possible to create a custom chart in the dashboard?

an_lam2 — Fri, 28 Jul 2023 01:00:30 GMT

@Felix Möhlmann Hi, you're correct about the wrong formula, my bad it should be LC/233 * Output, anyhow I have Finish building the custom chart and it works well.

Your browser does not support HTML5 video.

Just another query for me is, is it possible to inject the result of the calculated table in to the global table?

for example is below, I have assign the operator trigger on start task to write value of 1 in the global table 2, then I Sum the value of global table 2 in the calculated table to get the total MP working in the model, Is there a way to inject the result of the sum of the operated in the calculated table to Global table 1 in MP column?

or there is any other better way to do this?

Custom Dashboard.fsm

Re: Is it possible to create a custom chart in the dashboard?

moehlmann_fe — Fri, 28 Jul 2023 06:00:06 GMT

I would update the value in GlobalTable1 in the same trigger that changes the value in GlobalTable2. Then the MP value will always be up to date as well and you can forego the Calculated Table entirely.

You can use Table.query() to run a SQL query in code.

Re: Is it possible to create a custom chart in the dashboard?

an_lam2 — Fri, 28 Jul 2023 07:13:36 GMT

Hi @Felix Möhlmann, I'm quite lost with your instruction and Table.query, sorry about this but I'm not really familiar with programming languages, can you help by making an example so I can better understand. Thank you.

Re: Is it possible to create a custom chart in the dashboard?

moehlmann_fe — Fri, 28 Jul 2023 07:49:46 GMT

Here's a simple example model in which the global tables are updated in the queues' OnEntry trigger.

query-example.fsm

Re: Is it possible to create a custom chart in the dashboard?

an_lam2 — Fri, 28 Jul 2023 09:16:17 GMT

Hi @Felix Möhlmann I kind of understand the code script in queues trigger, after checking and trying it out with a task executor I'm getting an error, so I tried to use the Trigger On Start task "Write to GlobalTable" with a value of 1 for each operator, Then I use "user events" to paste and edit parts of the code you provided for table.query. In a way this is what I'm looking for but I'm not still sure, will doing like this is, okay?

Thanks alot!

Re: Is it possible to create a custom chart in the dashboard?

moehlmann_fe — Fri, 28 Jul 2023 10:11:57 GMT

It should work. But I don't see why you would need to update the sum value every second. If the values only change in the operators' trigger, then updating the sum in that trigger is enough to always have an up to date value.

Re: Is it possible to create a custom chart in the dashboard?

julie_weller — Wed, 02 Aug 2023 15:59:02 GMT

Hi @Aries Vash, was the answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.