Plot empty points in Line chart

[Ayestaran Nerea <na...@ikerlan.es>]

Hi everyone!

I have multiple variables in a Spark Dataset that I need to plot in Zeppelin. Those variables consist of a timestamp and a value but not all the variables have the same timestamps. For example:

 1. Variable a has values at:  |10:00|10:05|                                   |10:25|
 2. Variable b has values at:  |10:00|10:05|10:10|
 3. Variable c has values at:               |10:05|          |10:15|10:20|

Zeppelin treats those empty points as zeros, so the resulting line chart makes no sense. If I make a scatter plot, all the points are shown correctly but I need a line chart. Is there any way to plot the average value in those timestamps? Or even better, can I ignore those points and not plot them ?

I send you some pictures in case my explanation is not good enough.
[Selection_008.png][Selection_009.png]

As it can be seen in the scatter plot image, the zeros are not real, but are shown in the line chart. Is there any solution to my problem?

Thank you so much in advance
Nerea

Re: Plot empty points in Line chart

[moon soo Lee <mo...@apache.org>]

I think there should be code chances to address this problem.
Maybe line chart can have a checkbox option that user can select ignore
empty value or treats empty value as zero.

Do you mind file an issue for it?

Thanks,
moon

On Mon, Sep 12, 2016 at 8:11 AM Ayestaran Nerea <na...@ikerlan.es>
wrote:

> Hi everyone!
>
>
>
> I have multiple variables in a Spark Dataset that I need to plot in
> Zeppelin. Those variables consist of a timestamp and a value but not all
> the variables have the same timestamps. For example:
>
>
>
>  1. Variable a has values at:  |10:00|10:05|
>                               |10:25|
>
>  2. Variable b has values at:  |10:00|10:05|10:10|
>
>  3. Variable c has values at:               |10:05|          |10:15|10:20|
>
>
>
> Zeppelin treats those empty points as zeros, so the resulting line chart
> makes no sense. If I make a scatter plot, all the points are shown
> correctly but I need a line chart. Is there any way to plot the average
> value in those timestamps? Or even better, can I ignore those points and
> not plot them ?
>
>
>
> I send you some pictures in case my explanation is not good enough.
>
> [image: image001.jpg][image: image002.jpg]
>
>
>
> As it can be seen in the scatter plot image, the zeros are not real, but
> are shown in the line chart. Is there any solution to my problem?
>
>
>
> Thank you so much in advance
>
> Nerea
>
>
>
>
>