How to create a bar report for monthly results?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 12:04 PM
I would like to have a report that shows count of tasks month by month. What I have so far works to some degree but it gives data we don't want. It shows weekly data and I can't seem to keep it away.
We would also like to have each column have a different color.
I'm working on using multiple dataset to see if that will be a workaround but I should be able to report monthly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 07:18 PM
I beleive you need to remove the grouping by created. When you make a trend chart it will already group them by month.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 07:43 PM
I assume the grouping by month is being 'split' into weeks for the current month?
If, as test, you filter out tasks = this month?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2024 03:48 AM
Hi @Robert Campbell ,
Just created a time series report to shown data by created/opened etc. by month.:
Please note, that it's not possible to get each month in different color.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/