Ability to plot two metrics on a single chart

[cohenscottr]

Is your feature request related to a problem? Please describe. As a user, I want to be able to trend two metrics together (# of purchases, avg. purchase value) on the same chart

Describe the solution you'd like On the timeseries, have the ability to toggle a second timeline/axis and display multiple metrics across timeseries

[saisantoshv3]

I've two date columns, date_a and date_b, if i select only one date (date_a in this case) column as a timeseries, the dashboard is able to calculate aggregates( sum=36 and count=8) for only those values which are added in timeseries metric, its unable to calculate total count (15) of records and some of values(120)

also, is there a feature to add multiple columns as timeseries ?

[cohenscottr]

@saisantoshv3 think your comment is related to a different issue with two time series (created that here: https://github.com/rilldata/rill/issues/4446)

the above is about having two metrics on same chart.

for your example, can you explain a bit of the context on the two columns? seems like count on time series a should be 8 and should be 11 on time series b. if total count is desired, we'd either want to merge the two time series (or create a dash without the time series altogether)?

[saisantoshv3]

@cohenscottr spot on, my issue i want to have two time series, but is want to have count of all records even if there is blank cells in date column

[cohenscottr]

Hmm @saisantoshv3 - can you describe the scenario a bit?

If you're plotting data by time - how/why would those counts be relevant for alternate time periods that where there isn't time? I was thinking like Alex mentioned on the other thread - you'd end up merging the time series to display that way.

If you can provide a bit more detail, can see if we can modify the requirement to meet what you're looking for.

[saisantoshv3]

@cohenscottr yea, it would be better if we have multiple timeseries, but some how i want to see whole data in the dashboard and enable time series as filter only when I want to which isnt possible in this case

[cohenscottr]

@saisantoshv3 got it - that's a little different than the requirements on our roadmap. I do think the multiple time series is something we're looking into. it is possible to create a dash without timeseries as well.

right now - you'd be able to create the dash with no time series and one with time series to see the metrics side by side. let me discuss with our product team on possibilities for a workaround (guessing there won't be a short-term fix for the above minus the two dashboards - but we're working on some things with "custom" dashboards that would be more traditional charts that might accomplish what you're looking for in the next few weeks).