Dian Fay created ZEPPELIN-2969:
----------------------------------
Summary: Built-in line chart adds zeroed data points for missing
group values
Key: ZEPPELIN-2969
URL: https://issues.apache.org/jira/browse/ZEPPELIN-2969
Project: Zeppelin
Issue Type: Bug
Components: front-end
Affects Versions: 0.7.3, 0.7.2
Environment: Any
Reporter: Dian Fay
The line chart visualization invokes {{d3DataFromPivot}} with the
{{fillMissingValues}} parameter hard-coded to {{true}}. When values are missing
from a record set, such as in the below paragraph, this causes the chart to
plot zeroes where it would otherwise omit the missing points and draw lines
between real values only.
This behavior is not desirable in many circumstances since a fabricated value
of zero may not be distinguishable from a real value of zero. Since line charts
generally represent trends this is more a concern than it would be in a bar or
pie chart.
I suggest {{fillMissingValues}} should be {{false}} by default, and
configurable from the chart settings the way force y=0 and the focus chart
option are. If that sounds good, I have a fix ready to go and can submit a pull
request on GitHub.
{code}
%sh
echo -e
'%table\nname\tdate\ttotal\nAbc\t09/24/2017\t386\nAbc\t09/24/2017\t57\nAbc\t09/26/2017\t726\nAbc\t09/27/2017\t341\nAbc\t09/28/2017\t429\nAbc\t09/29/2017\t447\nAbc\t09/30/2017\t609\nAbc\t10/01/2017\t664\nDef\t09/24/2017\t828\nDef\t09/27/2017\t683\nDef\t09/28/2017\t312\nDef\t09/30/2017\t590\nDef\t10/01/2017\t581\nGhi\t09/24/2017\t792\nGhi\t09/24/2017\t112\nGhi\t09/24/2017\t897\nGhi\t09/24/2017\t719\nGhi\t09/27/2017\t786\nGhi\t09/28/2017\t853\nGhi\t09/29/2017\t777\nGhi\t09/30/2017\t453\nGhi\t10/01/2017\t977\nJkl\t09/24/2017\t790\nJkl\t09/27/2017\t469\nJkl\t09/28/2017\t137\nJkl\t09/29/2017\t774\nJkl\t09/30/2017\t458\nJkl\t10/01/2017\t988'
{code}
To view the described line chart behavior, set {{date}} as a key, {{name}} as a
group, and {{total}} as a value.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
