Is it possible to have a continuous timeline on the primary x-axis?

Example Data:

Issue ID	Status	DateCreated	DateClosed
1	Closed	11/15/2010	12/20/2010
2	Closed	11/23/2011	01/15/2011
3	Open	01/08/2011
4	Closed	01/12/2011	01/18/2011
5	Closed	01/13/2011	01/16/2011
6	Open	01/13/2011
7	Open	02/01/2011
8	Open	02/02/2011
9	Cancelled	02/05/2011	02/06/2011

I would like to create a Clustered Bar chart where there's a continous timeline from Nov 2010 to Feb 2011 on the x-axis and it shows the number of issues opened and resolved by the end of the month for each month based on the DateCreated and DateClosed values. 

Thank you.

Hello Wiewiek,
In the example data you provided, it looks like Issue ID 2 should have DateCreated for 2010. However, we would suggest the following approach for your requirement:

1. Once you connect to your data source from the Chart Designer, go to the Pivot tab.
2. From the Data Groupings – Categories tab create a new category.
In Data Groupings – Categories – General tab, set the following expression in the Label field: =FIRST(YEAR(Fields!DateCreated)) + "/" + FIRST(MONTH(Fields!DateCreated))
In the Group By section, add two fields and set the following expressions consecutively:
=YEAR(Fields!DateCreated)
=MONTH(Fields!DateCreated)


To sort the entries correctly, in Data Groupings – Categories – Sorting tab, add two fields and set the following expressions consecutively:
=YEAR(Fields!DateCreated)
=MONTH(Fields!DateCreated)


3. From the Data Groupings – Series tab, drag and drop the Status data set field to create a new series grouping:


4. From the Data Groupings – Values tab, add a new Value and set the following expression for the Data Values field: =Fields![RowCount]


Based on your sample data, this will generate the following chart:

Best Regards,
Nevron Support Team

Is there a way to include 12/10 and has no data on it?

Hi,

This is not possible in the current chart configuration, since it is not possible to inject dummy data points in the data source and the chart creates groups only for the records that are present. It can however be achieved via code or by creating a more sophisticated XY Scatter Cluster Bar chart, but you will have to submit a support ticket if you want us to help you with that.

Best Regards,
Nevron Support Team

Is it possible to have the charts to group the data based on different fields?
So for the example above, the open issues will be grouped by DateCreated field and the closed and cancelled issues will be grouped by DateClosed field.

Using similar data (I had changed the DateCreated of Issue ID 2)

Issue ID	Status	DateCreated	DateClosed
1	Closed	11/15/2010	12/20/2010
2	Closed	11/23/2010	01/15/2011
3	Open	01/08/2011
4	Closed	01/12/2011	01/18/2011
5	Closed	01/13/2011	01/16/2011
6	Open	01/13/2011
7	Open	02/01/2011
8	Open	02/02/2011
9	Cancelled	02/05/2011	02/06/2011

We will have a clustered bar chart
11/2010 shows 2 open and 0 closed/cancelled
12/2010 shows 0 open and 1 closed/cancelled
01/2011 shows 4 open and 3 closed/cancelled
02/2011 shows 3 open and 1 closed/cancelled

Hi Wiewiek,

This can be achieved via conditional categories grouping.

Please note that in your example, you have wrong calculations (there are no Open record for 2010).

 

You should use the following configuration in the Pivot:

 

Data Groupings / Values / General / Data / Value:

=Fields![RowCount]

 

Data Groupings / Categories / General / Label:

=IF(FIRST(Fields!Status)="Open", MONTH(FIRST(Fields!DateCreated)) + "/" + YEAR(FIRST(Fields!DateCreated)), MONTH(FIRST(Fields!DateClosed)) + "/" + YEAR(FIRST(Fields!DateClosed)))

 

Data Groupings / Categories / General / Group By (add two Expressions):

=IF(Fields!Status = "Open", YEAR(Fields!DateCreated), YEAR(Fields!DateClosed))

=IF(Fields!Status = "Open", MONTH(Fields!DateCreated), MONTH(Fields!DateClosed))

 

Data Groupings / Categories / Sorting (add two Expressions):

=IF(FIRST(Fields!Status)="Open", YEAR(FIRST(Fields!DateCreated)), YEAR(FIRST(Fields!DateClosed)))

=IF(FIRST(Fields!Status)="Open", MONTH(FIRST(Fields!DateCreated)), MONTH(FIRST(Fields!DateClosed)))

 

Data Groupings / Series / General / Label:

=IF(FIRST(Fields!Status) = "Open", "Open", "Close / Canceled")

 

Data Groupings / Series / General / Group By (add one Expression):

=IF(Fields!Status = "Open", 0, 1)

 

The produced chart will look like this:

Best Regards,
Nevron Support Team