cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Cumulative per day grouped by month

I capture "widgets" by day rather than a sum of them depending on what slice I use (could be monthly or quarterly or yearly for example).   How can I show a bar chart (see below) with average widgets per day?

 

 

 

 

Montly sum.png

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Cumulative per day grouped by month

@New2BInow

Not sure if I've got your idea 100%, however you could try to use the DATE istead of DATE Hierarchy.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors