Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hi
Thanks for quick reply.
But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.
Hi
Thanks for quick reply.
But I couldn't get the expected result. Please see the graph below. I need to combine create and closed date into one dimension.
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
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
Dear Stefan
Thank you for the solution. I got the output that I expected.
Regards
Abu
Hi Paul
Thank you for the reply. I got the solution from Stefan.
Regards
Mohamed Abubakker