Forum Discussion
Plot a bar graph
Hi there -
I have a table like below
| id | status | duration | date_only |
| E-4941 | In Progress | 12 | 11/9/2017 |
| E-4941 | Completed | 106 | 12/9/2017 |
| E-4942 | In Progress | 14 | 11/15/2017 |
| E-4942 | Completed | 108 | 12/15/2017 |
I need to plot a graph
x-axis - months ( should represent id's for status = 'completed') Eg: E-4941, E-4942
Y-axis - duration (sum of all 'In Progress' id's ) Eg: 12 + 14
(I tried to filter with 'status'=completed, but I get only 'completed' status duration ie; 106, 108 but I need 12, 14).
5 Replies
Anonymous your question is bit confusing, so you want to plot duration of in-progress for only those Id's which have status completed. correct?
