<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/jive/rss" version="2.0">
  <channel>
    <title>Content in Tableau Community Forums</title>
    <link>/profile-content.jspa?filterID=contentstatus[published]&amp;targetUser=41296</link>
    <description>Recent content in Tableau Community Forums</description>
    <language>en</language>
    <pubDate>Wed, 30 Jul 2014 16:17:13 GMT</pubDate>
    <generator>Jive Engage 8.0.5.0  (http://jivesoftware.com/products/)</generator>
    <dc:date>2014-07-30T16:17:13Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>Multiple date fields in single line graph</title>
      <link>https://community.tableau.com/thread/146053</link>
      <description>&lt;!-- [DocumentBodyStart:2c7be527-9e7f-4055-9ece-b43d10c09fb4] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a dataset with multiple dates fields associated with each record - eg Date received, Date accepted, Date published, etc.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;It looks something like:&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160; &lt;/p&gt;&lt;table border="0" cellpadding="0" cellspacing="0" style="width: 349px;"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td class="xl64" height="20" style="border:0px solid black;" width="64"&gt;UniqueID&lt;/td&gt;&lt;td class="xl65" style="border:0px solid black;" width="82"&gt;Date received&lt;/td&gt;&lt;td class="xl65" style="border:0px solid black;" width="101"&gt;Date accepted&lt;/td&gt;&lt;td class="xl65" style="border:0px solid black;" width="102"&gt;Date published&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;1&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;01/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;01/05/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;01/09/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;2&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;03/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;15/05/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;24/09/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;3&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;05/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;29/05/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;17/10/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;4&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;07/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;12/06/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;09/11/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;5&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;09/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;26/06/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;02/12/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;6&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;11/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;10/07/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;25/12/2011&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;7&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;13/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;24/07/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;17/01/2012&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;8&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;15/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;07/08/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;09/02/2012&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;9&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;17/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;21/08/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;03/03/2012&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td align="right" height="20" style="border:0px solid black;"&gt;10&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;19/01/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;04/09/2011&lt;/td&gt;&lt;td align="right" class="xl63" style="border:0px solid black;"&gt;26/03/2012&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;I would like to show a count of distinct records for each field using the same x-axis - that is &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;three separate lines on the same graph:&lt;/p&gt;&lt;p&gt;top line shows number of distinct records received in July 2014&lt;/p&gt;&lt;p&gt;second line shows number of distinct records accepted in July 2014&lt;/p&gt;&lt;p&gt;third line shows number of distinct records published in July 2014&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;The result would look something like &lt;a class="jive-link-external-small" href="https://community.tableau.com/external-link.jspa?url=http%3A%2F%2Fvizwiz.blogspot.co.uk%2F2013%2F03%2Ftableau-tip-displaying-multiple.html" rel="nofollow" target="_blank"&gt;this&lt;/a&gt; but note this uses a single date field to generate the axis and then adds multiple fields to the chart.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Hope that's clear. Much thanks in advance.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2c7be527-9e7f-4055-9ece-b43d10c09fb4] --&gt;</description>
      <category domain="https://community.tableau.com/tags#/?containerType=14&amp;container=2003">dates</category>
      <pubDate>Wed, 30 Jul 2014 16:17:13 GMT</pubDate>
      <author>tableaucommunity@tableau.com</author>
      <guid>https://community.tableau.com/thread/146053</guid>
      <dc:date>2014-07-30T16:17:13Z</dc:date>
      <clearspace:dateToText>4 years 11 months ago</clearspace:dateToText>
      <clearspace:replyCount>7</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

