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
