Time series data grouping

(Maddy M) #1


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?


(Brandon Kobel) #2

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

(system) #3

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