Plotting a calculation on a graph but limiting the calculation to the relevant week

alex-wb — Fri, 23 Apr 2021 08:07:31 GMT

Hi all,

I have the below calculation that works fine for me. However I need to plot this on a graph that is broken down into 52 weeks. How do I apply this calculation to run for each individual week since each week has a different amount of faults raised and also size of network.

count({ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"
}
>}FAULT_REF)

(sum({ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"}
>}PRODUCT_VOLUME)/
count(distinct{ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"}
>}G_DATE) /1000)

Re: Plotting a calculation on a graph but limiting the calculation to the relevant week

Dalton_Ruer — Fri, 23 Apr 2021 16:00:40 GMT

I would add a Week# field in your load script so that you can can use as a Dimension or Year-Week# or however you may need it for your rolling 52 weeks or just YTD.

That way you make the load script do the CPU work 1 time and your User Interface can fly.

topic Plotting a calculation on a graph but limiting the calculation to the relevant week in App Development

Plotting a calculation on a graph but limiting the calculation to the relevant week

Re: Plotting a calculation on a graph but limiting the calculation to the relevant week