title: How to chart a search that returns event with multiple facets that have a name/result pair in Splunk
body: <p>I am doing the following search:</p>
  
  <pre><code>source="new_relic_insights://NRInsightsAPI_rc_ShopFront_Top10Transactions"
  | search *
  | head 1
  </code></pre>
  
  <p>This returns a single event, and within its facets I have a name: xyz and results.sum: 123</p>
  
  <p>The sum corresponds to the name, and I need to chart these on a bar chart.</p>
  
  <p>Here is an example of what is returned:</p>
  
  <p><img src="https://i.imgur.com/Ja77fnQ.png" alt="alt text"></p>
  
  <p>Raw format:
  <img src="https://i.imgur.com/9F6WRSo.png" alt="alt text"></p>
  
  <p>This is what I have done so far to try to chart it, but because there are multiple values in one row, it doesn't work. Additionally the "total time" values aren't lined up with their corresponding result, for example 58245.xxx should be next to "WebTransaction/MVC/ProductController/Category" but it's not, again I assume this is because of them all being dumped into one row.</p>
  
  <p><img src="https://i.imgur.com/7gwBvzG.png" alt="alt text"></p>
  
  <p>Finally, I tried dedup/table to get what I needed and the results.sum line up with each name, however again trying to graph this groups all the values of name as one since they are in one row.</p>
  
  <p><img src="https://i.imgur.com/6OajMxo.png" alt="alt text"></p>