[Data warehouse] Monthly granularity not available when using reporting dates spanning exactly one month | Community
Skip to main content
L
leo_farfalle
Level 2
March 3, 2021
Solved

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

  • March 3, 2021
  • 3 replies
  • 1585 views

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.
Best answer by amgup

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

 

3 replies

A
amgupAccepted solution
Level 7
March 4, 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:-

 

L
leo_farfalleAuthor
Level 2
March 5, 2021

Hello Amgup,

When I choose:

 

Here is the error I get :

 

L
leo_farfalleAuthor
Level 2
March 7, 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!

Terms & ConditionsAccessibility statement

Loading footer...