Only show moving average after 4 quarters

Simon4 — Thu, 01 Jun 2023 09:47:21 GMT

Hi all,

I have a combination graph with a moving average for the margin. The moving average is calculated as follows:

rangesum(above(sum(OrderIntake) - sum(Kostprijs) ,0,4))/ rangesum(above(sum(OrderIntake) ,0,4))

OrderIntake = Revenue

Kostprijs = costprice

A screenshot from the graph:

I need the moving average to start after 4 Quarters, because otherwise it will not be a correct average. What are the options to hide the moving average line in the first 3 quarters?

Thankyou in advance

Kind regards,

Simon

Re: Only show moving average after 4 quarters

srchagas — Fri, 02 Jun 2023 09:46:08 GMT

Hi, What about something like this?

{<Your_DATA_FIELD ={<">=$(First_Q4_You_Want)<= $(Last_Q4_You_Want)">} rangesum(above(sum(OrderIntake) - sum(Kostprijs) ,0,4))/ rangesum(above(sum(OrderIntake) ,0,4))

topic Only show moving average after 4 quarters in App Development

Only show moving average after 4 quarters

Re: Only show moving average after 4 quarters