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

Bbyers3 — Wed, 31 Jan 2018 18:19:16 GMT

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

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

P_vandereerden — Tue, 18 Jun 2024 07:28:05 GMT

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?

topic How to create a Stacked Bar Chart for the category of month and week together? in Dashboards & Visualizations

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

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