Using CRXI Developer and SQL 2005 Express, I am developing a chart. The ‘On change of’ is by time period. I have a set of events for each time period and each event has an event type. Event type can be one of 6 known values. I need to create a formula that will sum data by time period, by event type. The show values in the chart will be the data for each event type (data value1 for event type1, datavalue1 for event type2,… and data value2 for event type1, data value2 for event type2,…).
What is the formula for doing this?
OR
Clarification/question – In the example above, since I actually have 2 on change of requirements (time period and event type) and I have 2 value requirements (data value1 and data value2), should I create 2 charts and overlay one on the other? Are there any formatting tricks to get the charts to line up appropriately?
Thanks so much for any help!!
What is the formula for doing this?
OR
Clarification/question – In the example above, since I actually have 2 on change of requirements (time period and event type) and I have 2 value requirements (data value1 and data value2), should I create 2 charts and overlay one on the other? Are there any formatting tricks to get the charts to line up appropriately?
Thanks so much for any help!!