Alterations to create experiments form

[vantaka2]

1) No need for both 'start date' & 'end date'; the only date needed is 'change Date'. Also instead of 3 drop down choices, this should be a datetime picker

2) Place Lookback window and anlaysis window on the same row:

3) Remove Active flag & Status on this page (upon creation, they should always be set to the default values)

4) For Assets - Can this be a multi select drop down or a checklist? The options for this should be the output of (Select asset_category from sensor_metadata where asset_category != '' group by 1 order by 1;)

[boiyelove]

What would change date do or represent?

[vantaka2]

start date = change date - lookback window end date = change date + analysis window

The app is meant to showcase the effects of a change which is made. The change date is the time that change was made. Hope this helps

[boiyelove]

Does change date mean date modified? Also this arithmetic seems to conflict with me models because due to blueprint of the data

change_date is date field lookback_window is integer field so start date = change date - lookback window would throw an error

[vantaka2]

"Does change date mean date modified?"

• It really depends on what you mean by modified. Its when something was modified at the chemical plant not when something was modified in the UI.

• If you cast Change date to date in postgres it should let you add & subtract integer values to get new dates, but please do keep the stored format as datetime

[boiyelove]

Okay. And what would these integer values represent in real life?

[vantaka2]

Days Lookback window of 7 = 7 days

[boiyelove]

Okay. Now that's clearer. I now understand how the arithmetic works

[boiyelove]

Meanwhile, date modified is the date the experiment data was last updated via the django UI