timestored
Feature request: transform - pivot - partition by value
user-jl
Feature request: transform - pivot - partition by value
Convert long table with tag to wide table with column to allow charting. Drawback is cost of sparse data.
- user-sl user-mpm
Automatic splitting of time series by tag like Grafana. We often work with time series data in a table format such as time, exchange, pnl. Ideally, Pulse could automatically display this as multiple series (one for each exchange). Since the set of exchanges varies by query and most databases do not support converting time, exchange, pnl into a wide format like time, exchange_1_pnl, exchange_2_pnl, a plot option to split the time series by a specified tag column (e.g., exchange) would be very useful.
pivot control can do this, but it shoudl be made more friendly:
`time xasc
{(select time,sym:`gold,price:gold from x) , select time,sym:`btc,price:bitcoin from x}
{ walk:{ [seed;n]
r:{{ abs ((1664525*x)+1013904223) mod 4294967296}\[y-1;x]};
prds (100+((r[seed;n]) mod 11)-5)%100};
c:{x mod `long$00:20:00.0t}x; st:x-c; cn:`long$c%1000;
([] time:.z.d+st+1000*til cn; gold:walk[100;cn]; bitcoin:walk[2;cn]) }[.z.t]