Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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
.
.
.
.
.
Thanks for your mail.
Please help me to construct the expression
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.
Here Suman take a look
Notes, the charts have the same results because there are the same 'open' and 'closed' numbers of id's
That means we need to change the file structure?Without change the structure how can I do that...please help
Hi,
It is not possible for me to change the file structure.
Open depends on requested date and closed depends on resolved date.
Thanks for your suggestion ..I have tried but couldn't.
Please help how can we do without change the table structure.
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.