Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Try this:
Create first expression as Count(<{COLUMN1={'SUCCESSFUL'}>}COLUMN1)
second expression as Count(<{COLUMN1={'FAILED'}>}COLUMN1)
hth
Sushil
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
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
Hi Revathy,
tis helped 🙂 Thank you very much !
Best Regards
Rainer