Hello,
I am very new to the JMP program, so I might be approaching this wrong at the moment. I am trying to create a report to help me monitor some work of mine and I want the report to automatically refresh everytime my raw data table is updated. Ex: When I login to JMP tomorrow, I want to open up my report with updated information. Below are the steps that I gone through to get to my report and I have included images of each step I take:
1) Raw data table that will be automatically updated, with 3 columns: Day of year, Cumulative, Customer
2) Analyze > Fit Y by X > Y, Reponse = Cumulative & X, Factor = Day of Year
3) Hotspot > Group by = Customer > Fit Line > Parameter Estimates > Make Combined Data Table
4) Table > Split > Split By = Term, Split Columns = Estimate, Group By = Customer
5) Update column name, add a few formulas, and added color gradient to help with monitoring my work
I essentially want that step 5 report to automatically update everytime my raw data table gets updated. I'm not too sure how to make that happen. I have tried saving it as a data table and saving a script, but have been unsucessful.
Any help will be greatly appreciated, and you can even tell me if my approach is completely wrong.
Thank you in advance!
![JMP_Step1_RawData.png JMP_Step1_RawData.png](https://community.jmp.com/t5/image/serverpage/image-id/10813i16983B55BCB538EE/image-size/medium?v=v2&px=400)
![JMP_Step2_FitYbyX_FitLine.png JMP_Step2_FitYbyX_FitLine.png](https://community.jmp.com/t5/image/serverpage/image-id/10814i12BC66A9DADA190A/image-size/medium?v=v2&px=400)
![JMP_Step3_CombinedDataTable.png JMP_Step3_CombinedDataTable.png](https://community.jmp.com/t5/image/serverpage/image-id/10815iB46D3ED9EA03C141/image-size/medium?v=v2&px=400)
![JMP_Step4_Step5_SplitTable_CustomizedReport.png JMP_Step4_Step5_SplitTable_CustomizedReport.png](https://community.jmp.com/t5/image/serverpage/image-id/10816i10C13C848F30D9AE/image-size/medium?v=v2&px=400)