expression construction help

[Anonymous]

Hi,

I have 3 columns-

ID Request_date closed_date

------------------------------------------------

1     2/3/2015      3/3/2015

2     3/3/2015      3/3/2015

i want to show trending of open vs close

Open- 2nd and 3rd -1 each

closed-3rd both

i am not able to make the expression condition

so closed is depend on closed_date and open is depend on request_date

Please help

[settu_periasamy]

Hi Suman,

Can you post the expected output in excel with above mentioned date?

[vincent_ardiet]

Hi,

Can you give us a sample of the expected result, it's not very clear for me your part:

Open- 2nd and 3rd -1 each

closed-3rd both

Regards,

Vincent

[Anonymous]

I want to show the representation on the line chart.

X axis- date

in the line- open and close count -two different line

[Anonymous]

If I find the count on day 2 open case is 1 and day 3 is 1.

On 3rd closed case count is 2

All I want to show on line chart

[vincent_ardiet]

I think that the cleanest way is to work a bit your datamodel.

If you can have a fact table linked to a calendar table.

In your fact table you have 2 flags for each id and date (either request or close date), flag_request and flag_close. Then you just have to sum those flags in your chart.

Regards,

Vincent