hc128168 opened a new issue #9737:
URL: https://github.com/apache/incubator-superset/issues/9737


   Hi,
   
   I wonder whether Superset offers a stepped line chart (I have been googled 
for quite some times but couldn't find any).
   
   It is like something like 
[this:](https://www.chartjs.org/samples/latest/charts/line/stepped.html).
   
   Useful case:
   - Showing the bid and the ask price of stock price over time in 1 single 
chart.
   - Or showing multiple time series in one chart.
   
   Currently, I have a database schema like this:
   symbol varhcar(16);
   is_bid boolean;
   price double;
   time timestamp(6);
   
   And then I use "time series - line chart" as the visualization type, 
"sum(price)" as metrics, and group by "symbol" and "is_bid".
   
   Then the chart will have many broken lines because not every timestamp for 
each set of symbol and is_bid exists for another set of symbol and is_bid.
   
   One solution is to have a script to get all the unique timestamps, and then 
populate additional rows per symbol per is_bid based on the previous value of 
the corresponding set of symbol and is_bid (as "step before interpolation" 
makes sense in this case), creating a giant table and additional work for all 
stepped line charts.
   
   Hence, it would be great that superset supports (or already supported) step 
line chart.
   
   Thanks.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to