Hi All,
I have a requirement where we need to display "values" with 0. We display the "balance" amount per month. The "balance" may be 0, but it would still contain details (debit and credit details as example). Users want the balance 0 displayed in "Charts" and then when they click on respective value, display detail records.
We have series to be displayed dynamically (based on filters user used in UI). There can be a max of 30 series per month. Hence we have used "stacked HTML5 charts" for implementing this. Apex 4.2 is being used.
Example data as follows: Month, Series A to E values:
Month series A B C D E
| DEC-2014 | 100 | 674.95 | 0 | 0 | 1680 |
| JAN-2015 | 200.10 | 848.52 | 0 | 0 | 7410 |
| FEB-2015 | 300.32 | -1796.74 | 0 | 0 | 4095 |
| MAR-2015 | 2010.44 | 700.13 | 0 | 0 | 4980 |
| APR-2015 | 19867.85 | 688 | 0 | 0 | |
| | | | | |
We find C and D has 0 values. In the charts only D gets displayed. It looks as though C is overwritten by D? But in column charts, both the 0's are displayed. How can we get this to work/display both 0 series in HTML5 stacked charts?
Please provide some inputs for fixing this.
Thanks,
Sumana