Calculated average for custom integer field per month

[jgrigg]

This seems like it should be easy enough, but I cannot figure out the right approach.

I have a column of custom imported integers. I want to provide an average (per month) of each month’s total divided by the number of issues in that month.

If I use Calculated Average, that averages for the entire dataset. And all other examples I see are around pre-calculated averages of other system generated fields.

Any ideas?

[Nacho]

That measure of MTTD if that is imported via Excel or whatever … could be done with a custom Measure like this:
"Avg MTTD "with format Decimal:

CASE WHEN [Measures].[Issues created] > 0 THEN
[Measures].[MTTD] / [Measures].[Issues created]
END

It needs the Time dimension as rows

[jgrigg]

Thanks Nacho. I had found this solution.

One note: Your CASE statement is missing WHEN.