Hi,
I have a app in appsheet to measure the processes.
First view I have table with Projects (there are ProjectID, ProjectName, Data, YourName). From the project I have 2 actions, to go to steps or chart.
Steps - a view where I can add steps of project (there are StepID, StepName, ProjectID [ref], Status). So the view show me only steps to the project I get in. Here we have two actions. First is start, and it start measure the time of step, mark the step that is active. Second action is Stop.
Last sheet in google sheet is StepsLog, where all these information is added (there are _RowNumber [key], StepID, StepName, Project ID, StartTime, EndTime and virtual columns - Duration and total duration of step).
I have problem with a chart. I would have a chart (could be pie chart or diffrent one), to have in order the steps from the highest total duration time. When I am trying to do it, I have only data to choose Rownumber, duration and total duration. But all of them base / count rownumber.
