Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

leo_farfalle
Level 2
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
amgup
Correct answer by
Level 7
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
amgup
Correct answer by
Level 7
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

leo_farfalle
Level 2
Level 2

Hello Amgup,

When I choose:

leo_farfalle_1-1614930298873.png

 

Here is the error I get :

leo_farfalle_0-1614930253283.png

 

leo_farfalle
Level 2
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!