Average Line from another table

I am trying to create a Column and Line chart with information from 2 tables. The first table has the date field and the main information with dates associated. The second table has other informati...

Need Help

PhillipB

Frequent Visitor

3 years ago

Thanks lbendlin

I have looked at TREATAS() but I am not sure that this is giving me what I need.

Date	Incident
1 jan 2022	A
3 jan 2022	B
8 jan 2022	A
19 jan 2022	A
2 feb 2022	C
4 feb 2022	A
8 feb 2022	B
10 feb 2022	C
14 feb 2022	A

Date	Quantity
2 jan 2022	3%
7 jan 2022	6%
9 jan 2022	5%
18 jan 2022	6%
4 feb 2022	5%
9 feb 2022	4%
11 feb 2022	6%
13 feb 2022	7%
14 feb 2022	3%

These two table are an example

And this is the kind of output but ideally I would like to show the line on the bar chart. The line is an average of per month, the bars are a count per month.

I can link the data but if I do that, either directly or via a calendar table (with days) neither works correctly.

Regards
Phillip