I'm trying to build a bar chart in a toad report that has volume tracked by day of month as well as day of week. How can I add both labels on my x-axis? I can accomplish this in excel and I'm attempting to replicate this in an automated report. The data set and chart currently look like:
DayOfMonth
DayOfWeek
Total
1
Mon
3
2
Tue
1
3
Wed
2
4
Thu
8
5
Fri
6
6
Sat
4
7
Sun
2
8
Mon
3
9
Tue
9
10
Wed
3
11
Thu
6
12
Fri
2
13
Sat
5
14
Sun
6
15
Mon
5
16
Tue
3
17
Wed
4
18
Thu
4
19
Fri
5
20
Sat
5
22
Mon
3
23
Tue
11
24
Wed
1
25
Thu
4
26
Fri
2
27
Sat
1
28
Sun
2
29
Mon
2
30
Tue
9
To Chris Unger:
Thank you for posting in Toad World!
I believe you can achieve this look creating an intermediary table with the DayOfMonth and DayOfWeek columns consolidated so that Toad Reporting can simply assign the consolidated column in the X axis. Your dataset can be exported to an excel file which can then be passed into the report for construction.
Let us know if you require further assistance,
Software Developer I,
-Joshua Liong
Thanks Joshua!
So that looks like it'll get me there. I had to create two calculated fields (which I can rememdy that on a query update with case statements).
DoW & DoM: existing fields in my source data.
1st calc field: Iif(DoW=1,'SU',Iif(DoW=2,'MO',Iif(DoW=3,'TU',Iif(DoW=4,'WE',Iif(DoW=5,'TH',Iif(DoW=6,'FR',Iif(DoW=7,'SA',0)))))))
2nd calc field: Concat(Concat([DoW_Name],' ' ),[DoM])