create a column indicating the shift

Question

question

kauan pedroso asked Apr 23 2023 at 1:33 PM Felix Möhlmann commented Apr 25 2023 at 7:45 PM

create a column indicating the shift

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?

Software Version:

FlexSim 21.2.4

global table sql server shift

· 2

Felix Möhlmann commented · Apr 24 2023 at 7:37 AM

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.

0 ·

kauan pedroso Felix Möhlmann commented · Apr 24 2023 at 8:17 PM

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 ?

0 ·

1682367432462.png (39.8 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2023-04-25T06:35:19Z

Felix Möhlmann answered Apr 25 2023 at 6:35 AM Felix Möhlmann commented Apr 25 2023 at 7:45 PM

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.

1682404458679.png (21.4 KiB)

· 8

kauan pedroso commented · Apr 25 2023 at 11:06 AM

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

0 ·

1682420768440.png (17.5 KiB)

1682420787659.png (20.2 KiB)

busca-de-dados-3-autosave-jl3-autosave.fsm (9.7 MiB)

Jason Lightfoot ♦♦ kauan pedroso commented · Apr 25 2023 at 11:45 AM

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)");

0 ·

kauan pedroso Jason Lightfoot ♦♦ commented · Apr 25 2023 at 2:06 PM

Hello @Jason Lightfoot

Thank you very much.

0 ·

Show more comments

Felix Möhlmann kauan pedroso commented · Apr 25 2023 at 12:26 PM

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.

0 ·

kauan pedroso Felix Möhlmann commented · Apr 25 2023 at 2:06 PM

Hello @Felix Möhlmann

Thank you very much.

0 ·

Show more comments

question