Frequency of the Chart Data

Question

question

Maryam H2 asked Dec 7, '21 Maryam H2 commented Dec 14, '21

Frequency of the Chart Data

Hi there,

How we can get the frequency of chart data. For example, If we create a calculated table to calculate the maximum "Wait Time for a Location" and the maximum wait time reports XX minutes, how we can get the frequency of that max value? I see in the "Person Statistic Tables> Person Wait Times" the value of wait times aggregated for all locations.

Thanks!

Software Version:

FlexSim 22.0.0

statistics collector wait times max wait time

Answer 1 · 2021-12-08T13:24:59Z

Felix Möhlmann answered Dec 8, '21 Maryam H2 commented Dec 14, '21

You can do this in a single query.

SELECT [colName], COUNT([colName]) FROM tableName GROUP BY [colName] ORDER BY [colName] DESC

will return a table with the values from the specified column in descending order next to the number of how often that value appears in the table. If you only want to see the highest value (which would always be in the first row) you can add "LIMIT 1" to the end of the query.

· 12

Maryam H2 commented · Dec 08, 2021 at 02:38 PM

@Felix Möhlmann Thanks for the answer!

I was wondering which query you meant. Do you mean the "Query" window under the "Calculation" tab in the relative calculated table? If so, do I need to add the query you mentioned in addition to the query that is already there?

In that case, I'm getting errors.

0 ·

Felix Möhlmann Maryam H2 commented · Dec 08, 2021 at 05:39 PM

Either use the table.query command and clone the result to a global table

table.query(...).cloneTo(Table("tableName"))

Rr directly in the query of a calculated table ("Enable direct editing").

WaitTimesCalcTable.fsm

0 ·

waittimescalctable.fsm (53.1 KiB)

Maryam H2 Felix Möhlmann commented · Dec 08, 2021 at 07:37 PM

waittimescalctable_1.fsm@Felix Möhlmann Thanks!

I'm getting errors. Could you take a look at the attached model and let me know how I can set a table or calculated table that gives me the frequency of max wait times?

0 ·

waittimescalctable-1.fsm (50.5 KiB)

Show more comments

question