Graph dimension question

[#1]

Hi,

I have a couple of line charts with the following dimensions and expressoins.

Chart 1:

Dimension: StartIntervalTime

Expression: COUNT(DataEventID)

Chart 2:

Dimension: EndIntervalTime
Expression: COUNT(DataEventID)

These produce the following two charts:

I however want to show both the graphs on a single chart. Usually I would simply add another expression but here both the charts are running from a different dimension.

How can I get both graphs onto the same chart?

Thanks in advance for your help with this.

Dan

[#2]

Hi,

From a single chart, use the second expression. Go to Axes tab, try to change the second expression possition to Right[top] and check the Split axes and change to value 50%.

[Anonymous]

Daniel,

I think the next approach will work:
Create data island with one field Intervals.  Create chart with Intervals as dimension, and the next two expressions:
StartCount = COUNT(if(StartIntervalTime=Intervals, DataEventID))
EndCount = COUNT(if(EndIntervalTime=Intervals, DataEventID))
Warning: the performance maybe be poor with a large amount of data.

Regards,
Michael

[#4]

Hi Dan, In the above case you need to create common IntervelTime (In Link table if required) for both fields and use this new field as the Dimension. Similarly create the FLAG weather its start or end .

Dimension: IntervelTime

Expression1: Count({<FLAG={'START'}>}DataEventID)

Expression2: Count({<FLAG={'END'}>}DataEventID)

[maxgro · Accepted solution]

see attachment

[Anonymous]

Here is a version with island (based on Massimo Grossi)