Group my barchart by weeks not days or months

**badmullah** · 09-19-2022, 04:21 AM

is there anyway that I could group by week
date filter allows me to say when to start ( After :such date )

I can group based on Years Quarters Months but not weeks...

I tried to introduce another column and label the days of the week by W1 , W2, W3

but there must be a way to do this without introducing an extra column and labeling the weeks.

Thanks

BARCHART-ISSUE.gif

**oeldere** · 09-19-2022, 04:36 AM

If I had offered you a solution, I would have added an extra column to determine the week.

Why do you think it is easier not using an extra column?

**badmullah** · 09-19-2022, 05:05 AM

Thanks but I don't want to populate a new column before I have Extra dates in my sheet.. I rather have the intelligence in the code to group it by weeks

**oeldere** · 09-19-2022, 05:10 AM

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

**oeldere** · 09-19-2022, 11:51 AM

Thanks for the rep.

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

**badmullah** · 09-19-2022, 07:29 PM

sample file is attached

**sandy666** · 09-19-2022, 07:40 PM

is that what you want?

Count of ClosedDateTime	Fix
Week of Month	CANCELLED	COMPLETE	FAILED	Grand Total
1		52	3	55
2	55	157	3	215
3	69	238	16	323
5	16	80	8	104
Grand Total	140	527	30	697

or

Count of ClosedDateTime	Fix
Week of Year	CANCELLED	COMPLETE	FAILED	Grand Total
36	16	132	11	159
37	55	157	3	215
38	69	238	16	323
Grand Total	140	527	30	697

**badmullah** · 09-19-2022, 08:03 PM

Not exactly
I have he bar charts in DAYS
I like to group them by WEEK in he barchart
so it would have 3 bars for 3 weeks starting from AUG 29th Monday for FIX

**sandy666** · 09-19-2022, 08:50 PM

try with this
you have more columns in source of pivot (Power Query Table)
maybe it will help

**badmullah** · 09-19-2022, 10:01 PM

Solution
Select pivot table
Grouping
put 7 at the bottom
Number if Days =7solution.png

Group my barchart by weeks not days or months

LinkBack

Thread Tools

Rate This Thread

Display

Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Re: Group my barchart by weeks not days or months

Thread Information

Users Browsing this Thread

Similar Threads

Adding days, weeks and months to my workbook

Adding days, weeks and months to my workbook

Count days, weeks and months between date range

RD calculation based on No.of weeks,days,months,years

RD calculation based on No.of weeks,days,months,years

[SOLVED] Returning 'Number' of 'Days' or 'Weeks' or 'Months' with # and text

Group data by weeks not months

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions