Time series data grouping

[Maddy_M]

Hi,

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?

Thanks,
Venkat

[Brandon_Kobel]

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