bodhankar.bvinay Posted February 26, 2014 Share Posted February 26, 2014 Hi All,i have below data in table now based on hour i need to develope bar chart to showTARGETED_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 GroupPlease 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_COUNTFROM LCMS_CAMPAIGN_ANALYSIS_NRT table(1).bmpexcpected chart is chart.bmp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now