[Data warehouse] Monthly granularity not available when using reporting dates spanning exactly one month

[leo_farfalle]

Hello,

I want to use Monthly granularity for all my reports.

Monthly granularity seems only available if I select the reporting date to be either 'Last Month' or greater than 1 month. 

It is not available for monthly kind of reports: let's say, today I want to retrieve a report covering June'2020.

Do you confirm this limitation? Any suggestion?

Thank you

[amgup · Accepted solution]

@leo_farfalle Are you not getting 'Monthly' granularity in drop down while selecting preset date less than a month?
Can you please share the screenshot of what you are getting or any error if you are getting ?

Refer the below screenshot:-

[leo_farfalle]

Hello Amgup,

When I choose:

Here is the error I get :

[leo_farfalle]

Hello Amgup,

Clicked Correct Reply by mistake.

I am still hoping for an answer.

How can I use Monthly granularity in my report when I select Custom date spanning a month?

Can you also explain what Granularity 'None' means for the raw data (any processing done on raw data before reporting).

Thanks!