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
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
leo_farfalle
Level 1

03-03-2021

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 10
Level 2
amgup
Level 2

Likes

15 likes

Total Posts

67 posts

Correct Reply

9 solutions
Top badges earned
Affirm 10
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Affirm 10
Level 2
amgup
Level 2

Likes

15 likes

Total Posts

67 posts

Correct Reply

9 solutions
Top badges earned
Affirm 10
Boost 5
Boost 3
Boost 10
Boost 1
View profile
amgup
Level 2

03-03-2021

@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

 

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
leo_farfalle
Level 1

07-03-2021

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!

Avatar

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
leo_farfalle
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
leo_farfalle
Level 1

04-03-2021

Hello Amgup,

When I choose:

leo_farfalle_1-1614930298873.png

 

Here is the error I get :

leo_farfalle_0-1614930253283.png