Linediagram with lines calculated from one column

[#1]

Hi wizzards :-),

I have a challange, and I need help. I would like to create a linediagram. The Dimension is time/date.

I have a column, in this example with 2 values (SUCCESSFUL and FAILED). I would like to have 2 lines with a count for each value like :

If (COLUMN1='SUCCESSFUL',Count(COLUMN1)) (this should be line 1) and If (COLUMN2='FAILED',Count(COLUMN1)), this should be line 2.

Your help would be appreciated

Thanks a lot

Rainer

P.S. if I am in a wrong area, sorry, it is my first question, so please correct me.

[sushil353]

Hi,

Try this:

Create first expression as Count(<{COLUMN1={'SUCCESSFUL'}>}COLUMN1)

second expression as Count(<{COLUMN1={'FAILED'}>}COLUMN1)

hth

Sushil

[Anonymous · Accepted solution]

HI

u can use the Date/time as dimension and in the expression use these two expressions

                              -  Count(if(Column = 'SUCCESSFUL', Column))

                              -   Count(if(Column = 'FAILED', Column))

Then u wil get two lines in ur Line chart..

Regards

Revathy

[#4]

Hi Sushil,

thank you for your fast response 🙂 !

I took this 2 expressions and inserted them as formulars in the diagram definition ( I hope this is what you ment) and in the diagram I found http://nodataavailable.com/"No Data Available" (hope this is the correct translation to the right "errorcode"

Thank you

Rainer

[#5]

Hi Revathy,

tis helped 🙂 Thank you very much !

Best Regards

Rainer