Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.