topic Re: create a column indicating the shift in FlexSim Forum

create a column indicating the shift

Kauan — Sun, 23 Apr 2023 13:33:52 GMT

[ FlexSim 21.2.4 ]

I have a global table that takes some data from sql server that brings me all the data but I would like to make a graph where I can see the performance of the morning, afternoon and night shifts. Is it possible in the charts to create a filter by date?

Re: create a column indicating the shift

moehlmann_fe — Mon, 24 Apr 2023 07:37:05 GMT

What data exactly do you want to plot in a chart: The data from your global table, the state/utilization of objects, a throughput value, ...?

In general, if you have time stamps, you can use the datetime class to create a column that denotes the shift the data point belongs to by using simple conditions like "DateTime(...).hour >= 8 && DateTime(...).hour < 16".

Once you have such a column you can partition the data by it, either in a calculated table if you need to filter/aggregate the other data first, or directly through the properties of certain chart types.

Re: create a column indicating the shift

Kauan — Mon, 24 Apr 2023 20:17:49 GMT

Hello @Felix Möhlmann

I think I didn't explain well what I want, I'm looking to make a bar chart where I can show the average cycle time per shift. I had an idea but I don't know if it's the best option, which is to create an extra column in my global table and identify which shift my cycle time is in. example if it is between 05:00 to 12:00 = T1 if it is from 12:01 to 22:00 = T2 and until 22:01 to 05:00 = T3. Is it possible to do that? Is it the most viable option ?

Re: create a column indicating the shift

moehlmann_fe — Tue, 25 Apr 2023 06:35:19 GMT

That is pretty much what I tried to describe in my comment. The code to determine would look something like this (missing the reference to the table that you would have to provide).

Table current = Table("GlobalTable1");
for(int row = 1; row <= current.numRows; row++)
{
    DateTime entryTime = DateTime(current[row]["InputTimestamp"]);
    if(entryTime.hour >= 5 && entryTime.hour < 12)
    {
        current[row][3] = 1;
        continue;
    }
    if(entryTime.hour >= 12 && entryTime.hour < 22)
    {
        current[row][3] = 2;
        continue;
    }
    current[row][3] = 3;
}

This code loops through the entire table. If you add the entries one by one you can of course directly compute the shift for just that row.

To then get the average into a bar chart you can use a calculated table to get the average value of the Difference column partitioned by the shift.

Either use the options on the first and third tab to generate the query or enable the direct editing to type it in manually.

Re: create a column indicating the shift

Kauan — Tue, 25 Apr 2023 11:06:56 GMT

in the code above it changes the value of my inputTimestap, how do I change the shift column. Another thing I will share the model, would you show me this calculated field better?

busca-de-dados-3-autosave-jl3_autosave.fsm

Re: create a column indicating the shift

jason_lightfoot_adsk — Tue, 25 Apr 2023 11:45:49 GMT

You can use this to set your shift number if shifts 1,2 and 3 correspond to 0-8hrs, 8-16hrs, 16-24hrs:

Table.query("UPDATE GlobalTable1 SET Shift = 1+(DateTime(InputTimestamp).hour>=8)+(DateTime(InputTimestamp).hour>=16)");

Re: create a column indicating the shift

moehlmann_fe — Tue, 25 Apr 2023 12:26:44 GMT

In my example model the Shift column was the third one in the table. You have the change the column number/name when assigning the shift values to reflect your table format.

Re: create a column indicating the shift

Kauan — Tue, 25 Apr 2023 14:06:38 GMT

Hello @Jason Lightfoot

Thank you very much.

Re: create a column indicating the shift

Kauan — Tue, 25 Apr 2023 14:06:52 GMT

Hello @Felix Möhlmann

Thank you very much.

Re: create a column indicating the shift

Kauan — Tue, 25 Apr 2023 17:38:01 GMT

One last doubt, I realized that both methods work and if I wanted to get a time with minutes. Example 12:30 what do i need to change to do this.

Re: create a column indicating the shift

Kauan — Tue, 25 Apr 2023 17:38:09 GMT

One last doubt, I realized that both methods work and if I wanted to get a time with minutes. Example 12:30 what do i need to change to do this.

Re: create a column indicating the shift

moehlmann_fe — Tue, 25 Apr 2023 19:45:52 GMT

You could add the minutes to the different conditions (DateTime.minute). But I would suggest to calculate the current time of day as a decimal hour value and compare the shift times to that.

As an example

DateTime entryTime = DateTime(current[row]["InputTimestamp"]):
double timeOfDay = entryTime.hour + entryTime.minute/60;
if(entryTime.hour >= 5 && entryTime.hour < 12.5)
{       
    current[row]["Shift"] = 1;      
    continue;
}
...