rill icon indicating copy to clipboard operation
rill copied to clipboard

Ability to add multiple time series dimensions as canonical time field

Open cohenscottr opened this issue 1 year ago • 2 comments

Is your feature request related to a problem? Please describe. For data with two time columns, would like to be able to switch the time series between the two fields (eg. impression and outcome time).

Describe the solution you'd like Time series charts (and associated charts) utilize the selected time series

cohenscottr avatar Mar 26 '24 20:03 cohenscottr

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)

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

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

PS: the same was posted here by me #4404

saisantoshv3 avatar Mar 27 '24 06:03 saisantoshv3

In this case I would probably merge the two columns so you have a uniform timeseries and create flags if you only want to sum date_a or date_b data.

We are planning to introduce the ability two have multiple timeseries but only 1 active at a time. That would be useful when you have two seperate instances of dates such as order_date and shipping_date that represents two different things.

mindspank avatar Mar 27 '24 07:03 mindspank