How to compare two similar data sets using a chart function ?

[Anonymous]

Hi all!

I have two data sets 'X' and 'Y' which are of similar data type having same header fields.

Eg; Data set 'X' is old data and 'Y' is the current refreshed data

How can I bring up these two data sets in a same bar graph next to each other as shown in the below snap?

Shall I store the data in two separate files or shall I just append these two data sets in single file ?

[sunny_talwar]

I think you should be able to append the two data sources, but may be add a flag to differentiate between old and new.... and then you can use this flag as one of the dimensions....

[Anonymous]

Can you plz elaborate more about the flag ? How to add it ?

[sunny_talwar]

I am not sure what is there to elaborate... but I can show you via a sample script... may be that will help clarify

Data:

LOAD blahblah...,

     'OldData' as DataFlag

FROM OldData;

Concatenate (Data)

LOAD blahblah,

     'NewData' as DataFlag

FROM NewData;

Now use DataFlag as your dimension

[Anonymous]

For the above code, data should be in different files/sheet right ?

It should not be appended.

[PrashantSangle]

Can you post some sample data???

Regards,

[sunny_talwar]

Not sure I understand