https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211642#M61924 <P>Thanks so much</P> Thu, 04 Aug 2016 02:55:53 GMT marcus933 2016-08-04T02:55:53Z https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211640#M61922 <P>I have the following 2 charts</P> <PRE><CODE>&lt;panel&gt; &lt;chart&gt; &lt;title&gt;HDB Resale index By Year&lt;/title&gt; &lt;search&gt; &lt;query&gt;source="HDB Resale price index by Year.csv" host="L31403" index="project_testing" sourcetype="csv"|chart first(extracted_index) by year|rename first(extracted_index) AS "Price Index"|rename year AS "Year"&lt;/query&gt; &lt;earliest&gt;0&lt;/earliest&gt; &lt;/search&gt; &lt;option name="charting.axisLabelsX.majorLabelStyle.overflowMode"&gt;ellipsisNone&lt;/option&gt; &lt;option name="charting.axisLabelsX.majorLabelStyle.rotation"&gt;0&lt;/option&gt; &lt;option name="charting.axisTitleX.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisTitleY.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisTitleY2.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisX.scale"&gt;linear&lt;/option&gt; &lt;option name="charting.axisY.scale"&gt;linear&lt;/option&gt; &lt;option name="charting.axisY2.enabled"&gt;0&lt;/option&gt; &lt;option name="charting.axisY2.scale"&gt;inherit&lt;/option&gt; &lt;option name="charting.chart"&gt;line&lt;/option&gt; &lt;option name="charting.chart.bubbleMaximumSize"&gt;50&lt;/option&gt; &lt;option name="charting.chart.bubbleMinimumSize"&gt;10&lt;/option&gt; &lt;option name="charting.chart.bubbleSizeBy"&gt;area&lt;/option&gt; &lt;option name="charting.chart.nullValueMode"&gt;gaps&lt;/option&gt; &lt;option name="charting.chart.showDataLabels"&gt;all&lt;/option&gt; &lt;option name="charting.chart.sliceCollapsingThreshold"&gt;0.01&lt;/option&gt; &lt;option name="charting.chart.stackMode"&gt;default&lt;/option&gt; &lt;option name="charting.chart.style"&gt;shiny&lt;/option&gt; &lt;option name="charting.drilldown"&gt;none&lt;/option&gt; &lt;option name="charting.layout.splitSeries"&gt;0&lt;/option&gt; &lt;option name="charting.layout.splitSeries.allowIndependentYRanges"&gt;0&lt;/option&gt; &lt;option name="charting.legend.labelStyle.overflowMode"&gt;ellipsisMiddle&lt;/option&gt; &lt;option name="charting.legend.placement"&gt;right&lt;/option&gt; &lt;/chart&gt; &lt;/panel&gt; </CODE></PRE> <P>I want to combine this chart with this:</P> <PRE><CODE>&lt;panel&gt; &lt;chart&gt; &lt;title&gt;Private properties index&lt;/title&gt; &lt;search&gt; &lt;query&gt;source="Private residential Properties Index.csv" host="L31403" index="project_testing" sourcetype="csv"|chart first(private_property_index) by year&lt;/query&gt; &lt;earliest&gt;0&lt;/earliest&gt; &lt;latest&gt;&lt;/latest&gt; &lt;/search&gt; &lt;option name="charting.axisLabelsX.majorLabelStyle.overflowMode"&gt;ellipsisNone&lt;/option&gt; &lt;option name="charting.axisLabelsX.majorLabelStyle.rotation"&gt;0&lt;/option&gt; &lt;option name="charting.axisTitleX.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisTitleY.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisTitleY2.visibility"&gt;visible&lt;/option&gt; &lt;option name="charting.axisX.scale"&gt;linear&lt;/option&gt; &lt;option name="charting.axisY.scale"&gt;linear&lt;/option&gt; &lt;option name="charting.axisY2.enabled"&gt;0&lt;/option&gt; &lt;option name="charting.axisY2.scale"&gt;inherit&lt;/option&gt; &lt;option name="charting.chart"&gt;line&lt;/option&gt; &lt;option name="charting.chart.bubbleMaximumSize"&gt;50&lt;/option&gt; &lt;option name="charting.chart.bubbleMinimumSize"&gt;10&lt;/option&gt; &lt;option name="charting.chart.bubbleSizeBy"&gt;area&lt;/option&gt; &lt;option name="charting.chart.nullValueMode"&gt;gaps&lt;/option&gt; &lt;option name="charting.chart.showDataLabels"&gt;all&lt;/option&gt; &lt;option name="charting.chart.sliceCollapsingThreshold"&gt;0.01&lt;/option&gt; &lt;option name="charting.chart.stackMode"&gt;default&lt;/option&gt; &lt;option name="charting.chart.style"&gt;shiny&lt;/option&gt; &lt;option name="charting.drilldown"&gt;all&lt;/option&gt; &lt;option name="charting.layout.splitSeries"&gt;0&lt;/option&gt; &lt;option name="charting.layout.splitSeries.allowIndependentYRanges"&gt;0&lt;/option&gt; &lt;option name="charting.legend.labelStyle.overflowMode"&gt;ellipsisMiddle&lt;/option&gt; &lt;option name="charting.legend.placement"&gt;right&lt;/option&gt; &lt;/chart&gt; &lt;/panel&gt; </CODE></PRE> <P>Basically I want to show these two charts as one.</P> Thu, 04 Aug 2016 01:59:32 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211640#M61922 marcus933 2016-08-04T01:59:32Z https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211641#M61923 <P>Try this for your query</P> <PRE><CODE>(source="HDB Resale price index by Year.csv" OR source="Private residential Properties Index.csv") host="L31403" index="project_testing" sourcetype="csv"| chart first(private_property_index)AS "Pvt Property Index" first(extracted_index) AS "Price Index" by year </CODE></PRE> Thu, 04 Aug 2016 02:39:05 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211641#M61923 sundareshr 2016-08-04T02:39:05Z https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211642#M61924 <P>Thanks so much</P> Thu, 04 Aug 2016 02:55:53 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-combine-these-two-charts-into-one-chart/m-p/211642#M61924 marcus933 2016-08-04T02:55:53Z