Two Tables, One Graph

[gfisch13]

Good morning everyone -

I have a situation where I want to report on two different data sources on the same graph.   Last year my company changed corporate credit cards.  I want to compare the spending levels by month.   I've created a simple bar graph with the first data source, dimension is Month, expression is SUM(TRAN_AMT).

In the second data source I've created the month field but with a slightly different name.  But when I try to add to the graph I'm unsure how to represent the new data.  Plus, I cannot select values from list boxes that represent the first source, with values from the second source.

Any guidance would help............Appreciate the time an attention.

Thanks,

George

[kumarkp412]

Hi George,

I hope this could be arrive based on mismatching the realation .

I hope you will have the relation ship between the two datasources. If yes, then onceagin recheck the relation between  the two datasources.

Can you upload a sample for better understaning and resolving you issue.

Thanks

Kumar KVP

[gfisch13]

Hi Kumar - the only relationship I can see here would be month/year.  Cannot see anything else that would relate.........other than employee there is really no other relation.

I'm sorry, I cannot upload a sample for this.

Thanks!

[anlonghi2]

Hello George,

you can try executing a concat between the first data source (Citi) and the second one (Amex) renaming the Amex field as Citi fields, remapping TRAN_TYP_CD codes on TRAN_CD_GRP and creating a field (ex.: CC_Brand) with 'Citi' value for Citi and 'Amex' for Amex data.

Please look at the script of attached app.

Best regards