Pentaho

I had been working on this for quite a few hours, and as I was putting together this question, I actually thought I had resolved this just now.

The question posed is close to working, however the values display as 0 sometimes. So I am not sure I am using the proper approach.

If anyone could help out, by pointing me to a resource that explains "how to", I would greatly appreciate it.

Lee

Hi Lee,

try this:

or, similarly, use the valuesMask option:

Cheers!

Thanks Duarte. These solutions do place the value2 in the text of the node. I like the brevity of the valuesMask.

However, there is still an issue where the labels display as zero for one of the lines.

This line chart is called from a clickAction on a bar chart which sets the "incident type" parameter for the line chart query then initiates a fireChange event. But one of the 'incident type" lines loads differently (as a sum?) .

One of the five categories of counts displays zeroes.

As shown in the image, the tooltip shows the count of 1 incident, however the node display 0.

Does the "sum" result not have the count in the ${#value2} element?

The other four categories of counts, the numbers display properly.

Any ideas how to code the chart to recognize when the result is a "sum", then use the different element?

Thanks again,

Lee

Hi Lee,

the sum symbol in the tooltip reveals that there are two rows in the dataset which have the same value of series and category. CCC handles this by summing the measures and displaying a single dot for both.

You could revise the query which returns this data set to return unique rows per combination of series and category value.

Otherwise, if you would simply like to emphasize the existence of two data points, you could display dots with a different shape, when the scene that they represent contains more than one row:

Cheers!