
Creator
2023-06-01
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Only show moving average after 4 quarters
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
342 Views
1 Reply

Creator III
2023-06-02
05:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
318 Views
