dynamic bar chart creation

[bodhankar.bvinay]

Hi All,

i have below data in table now based on hour i need to develope bar chart to show

TARGETED_COUNT,RESPONSE_COUNT for Target Group and TARGETED_COUNT,RESPONSE_COUNT for Control Group on hour basis.

But in table i have two records for same hour one is for  Target Group and one more is for Control Group

Please let me know how to give series expression and value expression in this scenario and plz find the expecetd chart in below. Thanks in advance..

SELECT DATE_KEY, HOUR, CAMPAIGN_ID, TARGET_CONTROL_GROUP,

TARGETED_COUNT,RESPONSE_COUNT

FROM LCMS_CAMPAIGN_ANALYSIS_NRT

 table(1).bmp

excpected chart is

 

 chart.bmp