topic Re: Creating a time series from static data in DQL

Creating a time series from static data

ian_molyneaux1 — Sun, 29 Jun 2025 09:14:42 GMT

Hi, If I have the following data record structure how can I create a timeseries from the content?

I just want to display each value in a bar graph - the timeseries interval is irrelevant in this case.

data record (D1 = toDouble($Day1),
D2 = toDouble($Day2),
D3 = toDouble($Day3),D4 = toDouble($Day4),D5 = toDouble($Day5),
D6 = toDouble($Day6),D7 = toDouble($Day7),D8 = toDouble($Day8),
D9 = toDouble($Day9),D10 = toDouble($Day10),D11 = toDouble($Day11),
D12 = toDouble($Day12),D13 = toDouble($Day13),D14 = toDouble($Day14),
D15 = toDouble($Day15),D16 = toDouble($Day16),D17 = toDouble($Day17),
D18 = toDouble($Day18),D19 = toDouble($Day19),D20 = toDouble($Day20),
D21 = toDouble($Day21),D22 = toDouble($Day22),D23 = toDouble($Day23),
D24 = toDouble($Day24),D25 = toDouble($Day25),D26 = toDouble($Day26),
D27 = toDouble($Day27),D28 = toDouble($Day28),D29 = toDouble($Day29),
D30 = toDouble($Day30),D31 = toDouble($Day31))

KR Ian

Re: Creating a time series from static data

Akhil-Jayendran — Mon, 30 Jun 2025 22:50:43 GMT

Hi @ian_molyneaux1 ,

Can’t you just show the data in a bar chart like this, without converting it into a time series? I think you’re trying to display the count for each day as bars, right?

data record(D = toDouble(15),timestamp = toTimestamp("2025-06-01T09:30:00.000-0400")), record(D = toDouble(10),timestamp = toTimestamp("2025-06-02T09:30:00.000-0400")), record(D = toDouble(12),timestamp = toTimestamp("2025-06-03T09:30:00.000-0400")), record(D = toDouble(14),timestamp = toTimestamp("2025-06-04T09:30:00.000-0400")), record(D = toDouble(8),timestamp = toTimestamp("2025-06-05T09:30:00.000-0400")), record(D = toDouble(23),timestamp = toTimestamp("2025-06-06T09:30:00.000-0400")), record(D = toDouble(67),timestamp = toTimestamp("2025-06-07T09:30:00.000-0400")), record(D = toDouble(1),timestamp = toTimestamp("2025-06-08T09:30:00.000-0400")), record(D = toDouble(34),timestamp = toTimestamp("2025-06-09T09:30:00.000-0400")), record(D = toDouble(2),timestamp = toTimestamp("2025-06-10T09:30:00.000-0400")) | summarize day_count = sum(D), by: {`interval` = bin(timestamp,24h)}

Re: Creating a time series from static data

ian_molyneaux1 — Fri, 04 Jul 2025 09:53:18 GMT

Hi Akhil,

Many thx this should be fine.

Ian