How to create a Stacked Bar Chart for the category of month and week together?

[Bbyers3]

So I have a question on how to report on multiple Categories.
I want it so the Graph has like below. In my table, I have the fields

Month ( 1 through 12)
Week (1 through 52)
platform (Virtual / Physical)

::: = Physical
--- = Virtual

Jan: Week1 (::::::::::::::::::::::::::::)(----------------------)
: Week2 (::::::::::::::::::::)(---------------------)
: Week3 (:::::::::::::::::::::::::::::::::::)(----)
: Week4 (:::::::::::::::::::::::::::::::::::::::)(-----------------------)

I am using this search below, and it works perfectly for either Week or Month but not both.

| dbxquery query="SELECT * FROM \"ESAO\".\"dbo\".\"CST.provisioning\" where Year = Year(GETDATE())" connection="ESAO_DB" | chart count Over Week by platform

[P_vandereerden]

Better late than never:

This needs more information on what you consider month and week boundaries. Does "January, Week 1" mean the first 7 days of January, January 1st to the last day of the week (e.g. Saturday), or the Sunday before January 1st, to the following Saturday?

When you say by week and month together, do you just want a label for the month in front of the 52 weeks?