Skip to main content
Gathering Interest

【Charts】Feature Request: Allow defining start/end points in Charts calculation formulas

Related products:Charts
  • June 11, 2026
  • 3 replies
  • 28 views

I would like to submit a product idea regarding Charts calculations.

Currently, calculations in Charts are performed only within the time range that is visible on the screen. We would like to request an enhancement that allows users to define a specific calculation period (i.e., start and end points) directly within the calculation formula.

For example, when using the “sample average” operator, the result is calculated only based on the data currently displayed. As a result, the calculated value changes when the user scrolls or shifts the visible time range.

We would like to be able to calculate metrics such as average values over a fixed, explicitly defined time range, including data outside of the current view. This would ensure that the result remains consistent and is not affected by scrolling or changes in the displayed window.

We believe this functionality would significantly improve usability and enable more stable and meaningful analysis.

Thank you for your consideration.

3 replies

Shun Takase
MVP ⭐️⭐️⭐️⭐️⭐️
Forum|alt.badge.img
  • MVP ⭐️⭐️⭐️⭐️⭐️
  • June 11, 2026

I also agree with this opinion.
Personally, when calculations using moving averages are scheduled, the results written can be incorrect depending on the moving average settings. This creates a risk that users may view these incorrect results and make wrong decisions.

Since moving average functions are also frequently used, I strongly hope that this behavior will be improved.


Everton Colling
Expert ⭐️⭐️⭐️⭐️
Forum|alt.badge.img
  • Expert ⭐️⭐️⭐️⭐️
  • June 12, 2026

Hi ​@Kubota Mami!

Thank you for suggesting this product idea. We will follow the traction this idea gets in the community. You can expect updates on this post if we decide to include this in our future roadmap, or if we require more information.


danielferraz
Expert ⭐️⭐️⭐️⭐️
  • Expert ⭐️⭐️⭐️⭐️
  • June 16, 2026

Hi ​@Kubota Mami and ​@Shun Takase 

Thank you very much for the request here. This is a fair request, and I can definitely see the value of viewing calculated data outside of the current chart view. 

A few questions from my side:
a) Is the most common calculation function for this particular need “moving averages”? Or does it extend to other calculation functions? 
b) Would configuring the calculation node be a fix here? For example, opening the “moving average” function node in the calculation UI and configuring the fixed time range to ensure that data outside the current view is included? 

We will evaluate this improvement and keep this post updated once I have a better sense of the timelines. 

Daniel Ferraz 
Product Manager