Toad World® Forums

Adding secondary x-axis detail

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])