Calculating Cumulative Totals by Date/Parameter

[mickalowe]

Hi All,

I'm having problems trying to build a cumulative graph based on 2 values from 2 tables. Line 1 needs to show time worked on a task drom <date a> to <date b> based on a specific activity, line 2 needs to be based on a budget of time starting at 0 from <date a> to the total value of the budget at <date b>.

Does this sound feasable? 

Thanks

Mick

[mickalowe]

Not sure what happened to my reply but I'll add it again....

First graph I want to accumulate TimeSpent by Project by NDate, the Y axis would start from the earliest NDate for Project and finish on the last NDate by Project:m the X axis would be TimeSpent

Code	Employee	NDate	TimeSpent	Project
149054	4	13/09/2018 00:00	15	3697
149060	4	13/09/2018 00:00	15	3815
149063	4	13/09/2018 00:00	15	3739
149064	4	13/09/2018 00:00	15	3891
149065	4	13/09/2018 00:00	15	3820
149221	4	12/09/2018 00:00	15	3836
149223	4	12/09/2018 00:00	15	3829
149224	4	12/09/2018 00:00	15	3939
149227	4	12/09/2018 00:00	15	3716
149230	4	12/09/2018 00:00	15	3751
149231	4	12/09/2018 00:00	15	3716
149235	4	12/09/2018 00:00	15	3837
149236	4	12/09/2018 00:00	15	3565
149240	4	11/09/2018 00:00	15	3829
149243	4	11/09/2018 00:00	15	3859
149247	4	11/09/2018 00:00	15	3175
149250	4	11/09/2018 00:00	15	3716
149266	4	10/09/2018 00:00	15	3751
149271	4	10/09/2018 00:00	15	3932
149272	4	10/09/2018 00:00	15	3858
149280	4	07/09/2018 00:00	15	3829
149284	4	07/09/2018 00:00	15	3939

The second graph needs to be a straight line from 0 to accumulated  total based on the dates above so eefectively a straight line.

Code	PosCode	Project	Activity	Expense	CostEst	BudTime
1	6	4			0	0
2	3	4			0	0
3	7	4			0	0
4	1	4			0	0
5	5	4			0	0
6	5	5			2000	0
18	6	331			4500	6000
19	7	331			4500	6000
20	9	3565			450	600
21	6	3565			1050	600
22	3	3565			2100	1200
23	1	3565			450	600
24	5	3565			1050	600
25	9	3565			450	600
26	6	3565			2200	2400
27	7	3565			2200	2400
46	9	3829			20000	60000
47	6	3829			20000	60000
48	3	3829			75000	60000
49	10	3829			45000	60000
50	7	3829			60000	60000
51	5	3829			95000	60000
70	9	3829			10000	30000

Hope this is clear and thanks for looking.

[speedramps]

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

Does the budget have a single value like this with no start date?
If so, then how do you want this compared with the actuals.
Please provide examples

[Anand24]

Hi @mickalowe ,
Can you provide some sample data and expected result?