question

Borja Lorenzo avatar image
0 Likes"
Borja Lorenzo asked Borja Lorenzo commented

How to use calculate table from statistic collector

Hello everyone
In the attached model, I want to be able to calculate the difference between the end time of the last task and the start time of the first task in a 'Calculated Table.' Ideally, I would like to use this value to display it in a table chart on the dashboard.
Could you help me configure it?"
Thank you in advance.
1736767345456.png

Simplificación Statistic Collector from List 250113.fsm

FlexSim 24.1.1
calculated tablestatistic collectorsql queries
1736767345456.png (197.1 KiB)
simplificacion-statistic-collector-from-list-25011.fsm (57.3 KiB)
5 |100000

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

1 Answer

Felix Möhlmann avatar image
1 Like"
Felix Möhlmann answered Borja Lorenzo commented Best Answer

Assuming that the value in the last row will always the highest the query would just be

  1. SELECT MAX(Tiempo_Final) - MIN(Tiempo_Inicial) AS EnterColumnNameHere FROM Tiempo_Produccion

(Enable direct editing on the "Calculations" tab of the Calculated Table to be able to enter this manually and set the Update Mode to "Always")

· 3
5 |100000

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

Borja Lorenzo avatar image Borja Lorenzo commented ·

Thanks a lot

It works like a charm
Adjunto el archivo resuelto.


Simplificación Statistic Collector from List 250113_1.fsm


0 Likes 0 ·
simplificacion-statistic-collector-from-list-25011.fsm (656.1 KiB)
Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·
Another answer to a duplicate question here.
0 Likes 0 ·
Borja Lorenzo avatar image Borja Lorenzo Jason Lightfoot ♦♦ commented ·

My answer here: https://answers.flexsim.com/comments/175728/view.html

0 Likes 0 ·