Following up on my question here. Perhaps this goes into a FAQ of some sort.
I’ve got time series data set (returned from SQL) which has 3 columns: timestamp, id, value. I was trying to plot a line per “id” with x-axis (timestamp) and y-value (value). The scatter plot works, but result is not nice looking (i.e. not a continuous line). The line graph does not work well for time series as it does in other BI type tools (e.g. re:dash) due to timestamps not having a value for all id’s. My work around is to either: a) Introduce filter by id - i.e. where id=“xyz” and then I get a nice line or area graph for a single ID. This works in my case only because the sum, min, avg etc don’t change the value as there is only value per time stamp for a given id. b) Switch to spark-sql and pull data into a frame using jdbc and then create a form input - list/drop down of unique ids that I can pass into the second query to display a line/area graph (I’d have to do the angular bind/listen etc) for a selected “id”. Another question: What is the rationale behind forcing sum, min, avg etc for the displaying the y-axis for line, bar, area graph and _not_ allowing a display of just the value? > On Dec 14, 2016, at 5:14 PM, t p <tauis2...@gmail.com> wrote: > > I’m using the plotting features of the table display system. I’m using the > postgres/psql interpreter. I noticed a few issues and I’m hoping that someone > can point me in the right direction to resolve these issues: > > 1) I’m unable to display a value on y-axis (number field) as is (it forces me > to use a value of min, max, avg, sum, count ) in a plot while using the > settings drop down > 2) I’d like to to use the group by feature and plot a line for each member of > group for time series data, however I end up getting cluster grouped visuals > (x-axis time and I get clusters on x-axis for each group). > > The only way I can get a graph to work is by using the scatter plot, which > allows me to plot the actual value, however that is not a connected/smooth > line. > > Currently using 0.6.1 version.
