How to get the accumulation of Monthly Target Data when i want to show that in Line Chart

[konidena]

Hi Team,

I have target data at only month level. I want to split that by day level and show accumulation by each day in line chart.

I am having sum(Target)/Networkdays(MonthStart, MonthEnd) to get the daily Target. Since I don't have daily level target at at the data level, How to get the accumulation at day level in the line chart.

I tried using Rangesum(Above(Sum(Target)/22,0,RowNo())). 

Can anybody help me.

[PrashantSangle]

if you have access to modify script. then try to build all logic in script only

use below code for your reference.

test:

Load *,Target/NetWorkDays(month_start,month_end) as day_wise_target;

Load *,MonthStart(Date#(Month,'DD-MM-YYYY')) as month_start,

MonthEnd(Date#(Month,'DD-MM-YYYY')) as month_end

    Inline [

Month, Target

01-04-2023,100

];

NoConcatenate

Final:

Load *, date(month_start+IterNo()-1) as month_date Resident test

while month_start+ IterNo()-1 < month_end

;

Drop table test;

Regards,

Prashant Sangle