How to get Stats values by Month as a Column?

[chrisboy68]

Hi,

I have a simple stats 

| stats values(Field1) sum(TB) by Field2 date_month 

This gives me one row for each month. 

Field1 10 Field2 Jan

Field1 15 Field2 Feb

I want to see it like below so each month is on the same row grouped by the fields. 

Field1 Field2 Jan 10 Feb 15

Tried transpose and some other suggestions. I just keep missing. 

Thanks,

Chris

[PickleRick · Accepted solution]

I'm not sure what the relation between the source sample and the target sample is, to be honest. But it seems that you could try xyseries.

[chrisboy68]

Yes. that was exactly what I was looking for.!