7 Replies Latest reply: Nov 29, 2011 1:54 AM by Mohamed Abubakker

# Create Chart Dimension from Two Fields Value.

Hi All,

I have to build a chart with open issues and closed issues for a range of period. Graph dimensions are,

X-Asis(Bottom) -> Period

Y-Axis -> Issue Count

In Issue Record, I have Create Date and Closed date as two different period.

I don't know how to combine Create Date and Closed Date for X Dimention.

Your Immediate Response is highly appreciated.

Regards

Abubakker

• ###### Create Chart Dimension from Two Fields Value.

You can make a Bar chart by compaining Createdate and closed date. In Chart properties under style tab you can set Group or Stacked  what ever you want.

• ###### Create Chart Dimension from Two Fields Value.

Hi

But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.

• ###### Re: Create Chart Dimension from Two Fields Value.

Hi

But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.

• ###### Create Chart Dimension from Two Fields Value.

You could use an additional data island for period (x-Axis) to draw against and your expressions then look like

=count( if(Period=[Closed Date], Issue))

resp.

=count( if(Period=[Create Date], Issue))

Period should have the same granularity (Date) and format (best is numerical representation of a Date data type) like Closed and Create Date.

Hope this helps,

Stefan

• ###### Re: Create Chart Dimension from Two Fields Value.

Dear Stefan

Thank you for the solution. I got the output that I expected.

Regards

Abu

• ###### Create Chart Dimension from Two Fields Value.

Hi there

You add Create Date as a Dimension

then you create two expressions:

One for all cases that have been created:

rangesum(above(Sum(Count),0,RowNo()))

and one for the cases that have been closed:

rangesum(above(Sum(if(isnull(CloseDate),0,Count)),0,RowNo()))

you should get the results you are looking for as per the example of the graph

Cheers

Paul

• ###### Re: Create Chart Dimension from Two Fields Value.

Hi Paul

Thank you for the reply. I got the solution from Stefan.

Regards

Mohamed Abubakker