How to create a bar report for monthly results?

Robert Campbell
Tera Guru

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.

 

 

RobertCampbell_2-1720723865591.png

 

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.

 

 

3 REPLIES 3

bammar
Kilo Sage
Kilo Sage

I beleive you need to remove the grouping  by created. When you make a trend chart it will already group them by month.

Tyson Elder
Tera Contributor

I assume the grouping by month is being 'split' into weeks for the current month?

If, as test, you filter out tasks = this month?

AndersBGS
Tera Patron
Tera Patron

Hi @Robert Campbell ,

 

Just created a time series report to shown data by created/opened etc. by month.:

AndersBGS_0-1720781190060.pngAndersBGS_1-1720781230887.png

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/