Hi there,
I need to upload data from Excel in the form of an S-curve. An S-curve consists of two axes, where the Y-axis represents the percentage of completion and the X-axis represents the date.
The problem I'm facing is that I need to load this data into the application to compare the planned progress with the actual progress, but I don't want to manually load each date and its corresponding percentage
S-curve is like this:
Week | Planning | Accumulated | Real |
week 1 | 0.133% | 0.13% | |
week 2 | 0.665% | 0.80% | |
week 3 | 0.532% | 1.33% | |
week 4 | 0.732% | 2.06% | |
week n | n | 100% |
Is there any way to upload data from spreadsheet?
Another issue is that I require a separate S-curve for each project, which means I need a new spreadsheet for each project.
thanks
Solved! Go to Solution.
@Julio_Moyano wrote:
Is there any way to upload massive data from app?
Unclear what you mean. You could populate the spreadsheet directly. From the app, you could use an Import a CSV file for this view - AppSheet Help action.
@Julio_Moyano wrote:
Another issue is that I require a separate S-curve for each project, which means I need a new spreadsheet for each project.
Instead, use a single table that includes a column that references the Project table.
@Julio_Moyano wrote:
Is there any way to upload massive data from app?
Unclear what you mean. You could populate the spreadsheet directly. From the app, you could use an Import a CSV file for this view - AppSheet Help action.
@Julio_Moyano wrote:
Another issue is that I require a separate S-curve for each project, which means I need a new spreadsheet for each project.
Instead, use a single table that includes a column that references the Project table.
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |