Reported Date & Completed Date in a Single List box

[#1]

Hello  All,

In an incident dump, we have incidents reported for the month of Jan 2015. [Reported Date Column]

Also the incidents closed for the month Jan 2015 which can be created in 2014 & Jan 2015 also.[Completed Date Column]

Now i need to have a list box of years 2014   2015 . selecting 2015 should show the Incidents Reported & Incident Closed in the Bar Chart.

Reported Date & Completed Date are two different columns.

How can i have the list box of Year which should take care of both [Incident Reported  & Incident Closed].

Can you please suggest me. Appreciate your valued response.

Thanks,

Sasikumar

[Anonymous]

Hi,

Data:

Load *,

[Reported Date Column] as [Date Column]

From Table;

concatenate

Load *,

[Completed Date Column] as [Date Column]

From Table;

Final:

noconcatenate

Load *,

Year([Date Column]) as Year

From Data;

Use Year Column in Listbox,when user makes a selection,Incidents Reported & Incidents Closed will be displayed on year selected.