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

[alex-wb]

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)

[Dalton_Ruer · Accepted solution]

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.