I want to find the average for the past 1 month.

[Paknanarn23]

I want to find the average in the graph for the past 1 month, my code looks like this which made my average incorrect. The average of the month Jan must be equal to 22876 is a valid value.

The graph shows incorrect values. please help me

[edwin]

it isnt clear what you want to achieve.  are you saying you want just a single number for AVG of JAN?  i suggest create a variable and add you expression for Jan (im sure you calculate the date) and make sure it ignores the selected date in your set analysis.  then add that into your chart.

[sidhiq91]

@Paknanarn23  Could you please provide some sample data and the expected output? That would help us to understand more and give us the output.

[Paknanarn23]

Yes, I want the AVG value only for the month Jan and display the sum values ​​for the current date and month.

As for the date I calculate like this

[Paknanarn23]

I want it to look like this But the value is not displayed correctly.