[Data warehouse] Monthly granularity not available when using reporting dates spanning exactly one month | Community
Skip to main content
leo_farfalle
Level 2
Mar 3, 2021 12:32 PM UTC
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
amgupAccepted solution
Level 7
Mar 4, 2021 6:32 AM UTC

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

 

View reply

3 replies

leo_farfalleAuthor
Level 2
Mar 7, 2021 1:02 PM UTC

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!

Translate
leo_farfalleAuthor
Level 2
Mar 5, 2021 7:45 AM UTC

Hello Amgup,

When I choose:

 

Here is the error I get :

 

Translate
amgupAccepted solution
Level 7
Mar 4, 2021 6:32 AM UTC

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

 

Translate
Terms & ConditionsAccessibility statement

Loading footer...