Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Date Filed, Actual field ,Target field
In the UI I have a date picker , On selecting the dates.. say for example jan to march. I need to sum the values between maximum values of each month.
maximum of jan month + max of feb + max of march.
How to do it in load script
@Prabhu1204 can you share a sample data and the expected output ?
@Prabhu1204 can you share a sample data and the expected output ?
@Prabhu1204 for example you can create in load script :
data:
load *,Month(Date) as MonthTmp;
LOAD Date(Date) as Date,
Actual
FROM
[C:\Users\admin\Downloads\sample input.xlsx]
(ooxml, embedded labels, table is Sheet1);
load MonthTmp,FirstSortedValue(Actual,-Date) as Value2 resident data group by MonthTmp;
and then for the output use :
sum(Value2)
output:
for jan to feb
until march:
Its not working for me.. Not sure what i am doing working. One for march i am getting the value