Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure I understand what you are looking for, do you have a sample you can share?
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
Hi,
thanks. good answer!
It's working fine, unless I'm missing the starts points for both graphs, any idea?
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))
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