Line Graph - 0 quantity display

[Former Member]

All,

The requirements for my line graph are as follows:

-Map the data to the graph based on hours and quantity.

-When the quantity is 0 - break the line. The line should not dip down to 0 and back up to the quantity. The line should stop at that point, and then continue on the next non-zero point.

I'm not sure how to stop the plotting on the graph when the quantity is 0.

Any ideas?

Thank you,

Michelle

[Former Member · Accepted solution]

Hi, Michelle.

The best way to achieve this would be to use either a SQL query or xMII's Business Logic Services to "transform" your dataset, replacing zero (0) values with NULL (SQL) or NA (xMII) values. This will give you the desired result.

If the data source is not SQL, you can do it with BLS.

Rick

[Former Member]

Changing the SQL worked!

Thank you,

Michelle

[jamie_cawley]

You may also need to convert the quantity datatype to string.

Regards,

Jamie