POC: Timeseries - Dynamic Scale of X Axis for dates

[dmtrjsg]

Context

We need a spike to check and validate how to best present the dynamic time scale on the time series charts - stacked line chart.

To-do

Review nivo.rocks stacked line chart and help define best way to present the X axis granularity for various scenarios.

• [ ] build a quick poc to validate that X Axis is displayed well
• [ ] How do we round up to round dates? 1/5/10/30..
• [ ] Confirm we can set DD Mmm YY format for labels
• [ ] See how presentation is impacted by screen size

ℹ️

Nivo Stream Chart Params and Code > Nivo StoryBook >

⚠️ outstanding question on the granularity of data

[dmtrjsg]

:question: Since the calendar picker is defined to a day level, safe to assume the data aggregation for time series will be done with a daily time step. Unless we have pre-agged tables for this data, this will be calculated on-the-fly by QN? Do we have an approach in mind, or does this need a chat?

@thesan @bedeho

[bedeho]

Since the calendar picker is defined to a day level, safe to assume the data aggregation for time series will be done with a daily time step. Unless we have pre-agged tables for this data, this will be calculated on-the-fly by QN? Do we have an approach in mind, or does this need a chat?

Aggregation happens client side, the query node only emits streams of raw events of different types which can be filtered only on whether they where emitted in a given block interval, specified in terms of block height. I dont believe you can directly even filter on clock time. @thesan will be able to provide the rest of the story here and picking the best approach.