https://community.splunk.com/t5/Splunk-Search/How-to-create-a-scatter-graph-of-chain-stores-on-the-y-axis-with/m-p/259629#M77837 <P>scatter graph returns number for both Y-Axis and X-Axis<BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.3.0/Viz/Datastructurerequirementsforvisualizations">http://docs.splunk.com/Documentation/Splunk/6.3.0/Viz/Datastructurerequirementsforvisualizations</A> and select Scatter charts link on the right panel</P> Tue, 06 Oct 2015 17:40:00 GMT afishkin_splunk 2015-10-06T17:40:00Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-scatter-graph-of-chain-stores-on-the-y-axis-with/m-p/259628#M77836 <P>I have Splunk indexing a file that contains information about the geographical location of stores:</P> <P>city, chain, numStores<BR /> Pasadena, Walmart, 0<BR /> Pasadena, Kmart, 1<BR /> Glen Burnie, Walmart, 1<BR /> Glen Burnie, Target, 1<BR /> Glen Burnie, Kmart, 1<BR /> Millersville, Target, 1</P> <P>I want to be able to plot this data into a scatter chart where the X-axis is the city, the Y-axis is the chain, and the "dot" appears at the intersection where the city has a store (similar to below, but the X's are dots and they are lined up in the column):</P> <PRE><CODE>Walmart| X KMart | X X Target | X X ----------------------------------------------------------------- Pasadena Glen Burnie Millersville </CODE></PRE> <P>Try as I might, I cannot even get the axes to display correctly. Is it possible to do what I am asking? I read in the "Data Requirments for Visualizations" document that I need to graph the events directly, so I tried this:<BR /> <CODE>index=foo | fields - _* | fields city, chain</CODE> (I get no results for this)<BR /> <CODE>index=foo | fields city, chain</CODE> (I don't see any plots, but the legend shows up with city and _time. The x axis is labeled city, but no values are displayed and the y-axis shows values 50 and 100 which are not even in the data.)</P> <P>I wish I could paste the graph here, but my Splunk is on a closed instance so I have to retype everything here.</P> Tue, 06 Oct 2015 14:22:02 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-scatter-graph-of-chain-stores-on-the-y-axis-with/m-p/259628#M77836 lyndac 2015-10-06T14:22:02Z https://community.splunk.com/t5/Splunk-Search/How-to-create-a-scatter-graph-of-chain-stores-on-the-y-axis-with/m-p/259629#M77837 <P>scatter graph returns number for both Y-Axis and X-Axis<BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.3.0/Viz/Datastructurerequirementsforvisualizations">http://docs.splunk.com/Documentation/Splunk/6.3.0/Viz/Datastructurerequirementsforvisualizations</A> and select Scatter charts link on the right panel</P> Tue, 06 Oct 2015 17:40:00 GMT https://community.splunk.com/t5/Splunk-Search/How-to-create-a-scatter-graph-of-chain-stores-on-the-y-axis-with/m-p/259629#M77837 afishkin_splunk 2015-10-06T17:40:00Z