Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 7

@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:-

amgup_0-1614839472315.png

 

View solution in original post

3 Replies

Avatar

Correct answer by
Level 7

@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:-

amgup_0-1614839472315.png

 

Avatar

Level 2

Hello Amgup,

When I choose:

leo_farfalle_1-1614930298873.png

 

Here is the error I get :

leo_farfalle_0-1614930253283.png

 

Avatar

Level 2

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!