Is there a way to perform a insertion of data by the user and then do a calculation in script before showing results to user?
Nowadays user alter data by using an inputfield and calculation is done in the front end, in chart expression, which is taking 3 minutes to show results.
COUNT(distinct if([Date of Maintenance]>=[WORK_DAY],if(lastworkdate([Date of Maintenance], Round(([Days of Maintenance]/vDays),1))<=[WORK_DAY],[S/N])))* (METER * vConvert)
Set Analysis
count(distinct {$<WORK_DAY={"<=[Date of Maintenance] and >=lastworkdate([Date of Maintenance], Round(([Days of Maintenance]/vDays),1))"}>}[S/N]) * (METER * vConvert)
The results in first formula is correct, but takes longer as my dataset is big.
In this formula I have only the initial date of maintenance and last date. In chart, client is supposed to see all days from initial to last. That's why i had put <= and >=.
The dataset does not have these dates preload, either because user can change the Date of Maintenance and divide Days of Maintenance per another value.
Do you have any idea of how can I solve it through set analysis?
