Line chart

[Anonymous]

I have 3 columns based on the data value i want to show line chart-

id	Open	closed	status
1	9/1/2015	9/2/2015	closed
2	9/1/2015	9/1/2015	closed
3	9/2/2015	9/2/2015	closed
4	9/3/2015	9/3/2015	closed
5	9/4/2015	9/5/2015	closed
6	9/5/2015	9/5/2015	closed
7	9/5/2015		open

[#2]

Sumun, you need to create a new table like below in the script.

id     Date       Status

1     9/1/2015   Open

1     9/2/2015   Close

2     9/1/2015   Close

.

.

.

.

.

[Anonymous]

Thanks for your mail.

Please help me to construct the expression

[jonathandienst]

Build a qvw model with the data and make your best effort. Then, when you get stuck, you can ask for some assistance. If you have shown that you have put some effort in yourself, you will get much more help from others.

[miguelbraga]

Here Suman take a look

Notes, the charts have the same results because there are the same 'open' and 'closed' numbers of id's

[Anonymous]

That means we need to change the file structure?Without change the structure how can I do that...please help

[Anonymous]

Hi,

It is not possible for me to change the file structure.

Open depends on requested date and closed depends on resolved date.

[Anonymous]

Thanks for your suggestion ..I have tried but couldn't.

Please help how can we do without change the table structure.

[jagan · Accepted solution]

Hi Suman,

Without changing the script it is not possible to handle this, change your script like below

Data:

LOAD

id,

Open AS Date,

'Day' & Day(Open) AS Day,

'Open' AS Status

FROM DataSource;

Concatenate(Data)

LOAD

id,

closed AS Date,

'Day' & Day(closed) AS Day,

'Close' AS Status

FROM DataSource;

Now in chart simply try like this

Chart : Line Chart

Dimension: Day, Status

Expression: Count(Status)

Hope this helps you.

Regards,

Jagan.