Current Count of Months

[asecchin]

I am creating a story and need a count of months (including current) in the current year. I'll use it to calculate the average monthly revenue, adding all sales and diving it by the count of months (maybe if I could get an int return for the current month, it would solve the issue). Any ideas?

[alexandru_negoescu]

Hello Attila,

I confirm that the solution from jensbraun is working perfectly fine.

Here two ways to achieve that:

1. Create an Average aggregation on your story using the date:

Than you drill down in your report to month level (you have to use date hierarchy for your widget axis)

2. You create a new dimension into your story called Month:

Than you create an Average aggregation where you use as aggregation dimension your new calculated dimension, Month:

When you compare the results between the first approach and the second, you will get the same results.

Regards

Alex