Time series data grouping


I have values like below and I would like to create a timeseries/line chart with groupby ID field.

Id=1234 A=1, B=3, C=6, D=9
Id=2345 A=2, B=1, C=7, D=5
Id=2345 A=4, B=6, C=5, D=0

X-axis is timestamp
Y -axis, values(lines) for A,B,C,D groupby ID.

I am able to create lines chart with all values but unable to group the values by ID.

Could you please advise?


Hey @Maddy_M, you can create a terms aggregation on the “id” column and it’ll do the equivalent of a group by.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.