Line Chart showing values separately

[Anonymous]

Hello,

i created a line chart with an time dimension and 4 formulas.

COUNT({CompiGroup1}Text)  --> visualization = line

COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text))  --> visualization = only values

COUNT({CompiGroup2}Text) --> visualization = line

COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text))  --> visualization = only values

It's showing the values for each alternate states in the same graph. my requirement is to have it separated.

Is there any grouping function? (one Group for each alternate state)

Thanks

[sunny_talwar]

Not sure I understand what you are looking for, do you have a sample you can share?

[swuehl]

Try only two expressions:

Dual(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text)), COUNT({CompiGroup1}Text) ) --> visualization = line and values on data points

Dual( COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text)), COUNT({CompiGroup2}Text)) --> visualization = line and values on data points

[Anonymous]

Hi,

thanks. good answer!

It's working fine, unless I'm missing the starts points for both graphs, any idea?

[Anonymous]

finally I got it. thanks

DUAL(IF(ISNULL(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text))), '',COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text))),COUNT({CompiGroup1}Text))

[Anonymous]

Dual(COUNT({CompiGroup1}Text)-Above(COUNT({CompiGroup1}Text)), COUNT({CompiGroup1}Text) ) --> visualization = line and values on data points

Dual( COUNT({CompiGroup2}Text)-Above(COUNT({CompiGroup2}Text)), COUNT({CompiGroup2}Text)) --> visualization = line and values on data points