Data changes when picking months

[cbaqir]

Can someone please help me understand why the data would change when selecting a few months? This graph doesn't look right:

When I zoom in on the last 12 months, the data changes but this looks better to me:

[niclaz79 · Accepted solution]

Hi,

You are using an aggregated average for each date that is dependent on the total amount of dates available. By changing the amount of dates the calculation changes for each period.

If you are expecting non-changing values I would either not use an aggr() expression or if you want to keep it I would ensure that the same amount of dates are used regardless of what is selected.

[cbaqir]

I am trying to show the Avg # of tickets (DEFECT_ID) created per person (DETECT_BY) per month and then the % released.

How else could I do that without the aggr?

=avg(aggr(Count({$<PRIMARY_DECISION_BODY-={'SMG Committee'}>}DISTINCT DEFECT_ID),DETECT_BY))