https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/591275#M48497 <P>Yes. that was exactly what I was looking for.!</P> Tue, 29 Mar 2022 14:34:10 GMT chrisboy68 2022-03-29T14:34:10Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/590929#M48484 <P>Hi,</P> <P>I have a simple stats&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">| stats values(Field1) sum(TB) by Field2 date_month </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>This gives me one row for each month.&nbsp;</P> <P>Field1 10 Field2 Jan</P> <P>Field1 15 Field2 Feb</P> <P>I want to see it like below so each month is on the same row grouped by the fields.&nbsp;</P> <P>Field1 Field2 Jan 10 Feb 15</P> <P>Tried transpose and some other suggestions. I just keep missing.&nbsp;</P> <P>Thanks,</P> <P><BR />Chris</P> Fri, 25 Mar 2022 20:47:50 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/590929#M48484 chrisboy68 2022-03-25T20:47:50Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/590939#M48485 <P>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.</P> Fri, 25 Mar 2022 20:50:36 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/590939#M48485 PickleRick 2022-03-25T20:50:36Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/591275#M48497 <P>Yes. that was exactly what I was looking for.!</P> Tue, 29 Mar 2022 14:34:10 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-get-Stats-values-by-Month-as-a-Column/m-p/591275#M48497 chrisboy68 2022-03-29T14:34:10Z