2 Replies Latest reply on Oct 10, 2017 9:16 AM by Adam Langmaid

    Overlaying data with different axis

    Adam Langmaid

      I have a data set that includes filing date and approval date and I want a simple bar chart that displays filings for each filing year and approvals for each approval year, but Tableau can't seem to do this. Instead it will display filings and approvals by one date type (either filing date or approval date). Does anyone know how to do this?

       

      Here's a sample of the data set:

       

       

      File DateApproval Date
      12/11/200610/12/2007
      4/27/200710/12/2007
      4/16/200710/16/2007
      9/29/200610/29/2007
      4/2/200611/14/2007
      5/25/200712/13/2007
      4/30/200412/17/2007
      7/20/20071/18/2008
      4/3/20061/25/2008
      5/29/20072/27/2008
      12/19/20052/29/2008
      9/20/20073/20/2008
      5/14/20074/10/2008
      2/27/20064/22/2008
      4/1/20074/24/2008
      6/25/20045/20/2008
      12/26/20076/23/2008
      7/16/20077/3/2008
      7/2/20078/1/2008
      9/27/20058/15/2008
      10/11/20078/22/2008
      3/21/20089/19/2008
      12/13/200710/8/2008
      9/28/200710/28/2008
      3/27/200610/31/2008
      11/17/200511/14/2008
      12/19/200711/20/2008
      1/23/200811/20/2008
      9/27/200712/12/2008
      6/16/200812/15/2008
      12/15/200312/22/2008
      2/28/200812/24/2008
      12/18/20071/14/2009
      12/15/20042/13/2009
      6/30/20083/30/2009
      6/27/20084/7/2009
      6/15/20074/9/2009
      6/24/20084/24/2009
      11/29/20074/29/2009
      9/27/20075/6/2009
      10/23/20075/19/2009
      6/2/20085/28/2009
      12/17/20086/17/2009
      6/11/20057/1/2009
      12/26/20077/10/2009
      6/30/20087/31/2009
      10/3/20088/3/2009
      8/31/20078/13/2009
      12/31/20078/21/2009
      11/12/20089/8/2009
      12/18/20069/11/2009
      3/24/20099/24/2009
      11/29/20079/25/2009
      12/19/200810/19/2009
      1/29/200910/26/2009
      1/12/200911/5/2009
      10/16/200811/16/2009
      9/21/200812/1/2009
      11/19/20071/8/2010
      4/22/20091/22/2010
      5/23/20081/25/2010
      2/27/20092/2/2010
      8/31/20092/26/2010
      6/18/20093/18/2010
      10/1/19993/30/2010
      7/6/20095/6/2010
      5/30/20085/24/2010
      12/15/20086/1/2010
      3/31/20106/17/2010
      9/29/20097/28/2010
      7/2/20097/30/2010
      10/15/20098/13/2010
      10/30/20089/14/2010
      12/21/20099/21/2010
      4/19/201010/19/2010
      12/30/200910/28/2010
      12/30/200910/29/2010
      5/29/200911/10/2010
      3/29/201011/15/2010
      3/9/20091/14/2011
      1/22/20091/18/2011
      3/22/20101/21/2011
      4/27/20102/25/2011
      7/17/20092/28/2011
      6/7/20103/9/2011
      5/14/20103/14/2011
      6/17/20103/25/2011
      1/9/20094/6/2011
      6/25/20094/6/2011
      7/7/20104/6/2011
      12/20/20104/28/2011
      7/2/20105/2/2011
      11/15/20105/13/2011
      7/23/20105/20/2011
      11/23/20105/23/2011
      11/30/20105/27/2011
      10/30/20096/10/2011
      6/29/20096/15/2011
      12/18/20087/1/2011
      7/28/20087/1/2011
      11/16/20097/20/2011
      4/28/20118/17/2011
      2/28/20118/19/2011
      10/26/20078/25/2011
      3/30/20118/26/2011
      1/30/200910/14/2011
      12/23/201010/21/2011
      6/3/201111/16/2011
      2/18/201111/18/2011
      10/29/201011/18/2011
      7/18/20111/17/2012
      3/25/20111/23/2012
      4/14/20111/27/2012
      9/8/20111/30/2012
      10/18/20111/31/2012
      1/7/20112/10/2012
      4/13/20043/6/2012
      5/27/20113/27/2012
      9/17/20104/6/2012
      6/29/20114/27/2012
      4/26/20105/1/2012
      12/4/20116/8/2012
      12/22/20096/27/2012
      8/29/20116/28/2012
      9/16/20117/16/2012
      9/27/20117/20/2012
      6/23/20117/23/2012
      2/3/20128/3/2012
      10/27/20118/27/2012
      11/30/20098/29/2012
      8/9/20118/30/2012
      5/22/20128/31/2012
      11/17/20119/4/2012
      12/12/20119/12/2012
      8/12/20119/12/2012
      4/27/20129/27/2012
      4/17/201210/17/2012
      12/22/201110/22/2012
      9/8/200910/26/2012
      10/21/201111/6/2012
      5/29/201211/29/2012
      2/17/201212/14/2012
      9/27/201212/14/2012
      5/14/200912/14/2012
      2/29/201212/21/2012
      11/30/201112/21/2012
      9/28/201112/28/2012
      6/29/201212/28/2012
      12/5/201112/31/2012
      12/27/20071/25/2013
      9/22/20081/25/2013
      11/22/20111/25/2013
      3/29/20121/29/2013
      4/10/20122/8/2013
      8/27/20122/22/2013
      4/26/20122/26/2013
      8/10/20113/13/2013
      9/20/20123/20/2013
      2/27/20123/27/2013
      5/31/20123/29/2013
      7/12/20125/10/2013
      12/14/20125/15/2013
      7/30/20125/29/2013
      8/3/20125/29/2013
      11/15/20127/12/2013
      12/17/20128/12/2013
      10/2/20129/30/2013
      10/3/201210/3/2013
      2/8/201310/8/2013
      10/19/201210/18/2013
      10/26/201210/25/2013
      4/22/201311/1/2013
      3/30/200911/8/2013
      6/28/201311/13/2013
      12/11/201211/14/2013
      3/28/201311/22/2013
      4/8/201312/6/2013
      12/18/201212/18/2013
      12/28/20101/8/2014
      5/31/20131/31/2014
      3/29/20132/14/2014
      9/28/20112/18/2014
      3/27/20132/24/2014
      12/21/20123/19/2014
      4/19/20133/19/2014
      3/21/20133/21/2014
      1/14/20134/15/2014
      8/23/20134/21/2014
      8/30/20134/23/2014
      12/24/20134/29/2014
      5/10/20135/8/2014
      6/20/20135/20/2014
      12/20/20045/23/2014
      7/26/20126/6/2014
      10/21/20136/20/2014
      12/9/20137/3/2014
      7/29/20137/7/2014
      12/6/20137/23/2014
      5/14/20127/31/2014
      3/5/20138/1/2014
      2/8/20088/6/2014
      8/30/20128/13/2014
      5/16/20138/15/2014
      9/20/20138/19/2014
      2/27/20149/4/2014
      9/16/20139/16/2014
      9/18/20139/18/2014
      2/10/201410/10/2014
      9/27/201310/10/2014
      12/21/201110/10/2014
      5/2/201410/15/2014
      11/4/200910/15/2014
      9/19/201412/3/2014
      4/25/201412/17/2014
      4/21/201412/19/2014
      2/3/201412/19/2014
      4/21/201412/19/2014
      12/23/201312/19/2014
      7/30/201412/22/2014
      1/8/20141/8/2015
      10/24/20131/21/2015
      10/23/20131/23/2015
      8/13/20142/3/2015
      8/14/20142/13/2015
      3/24/20142/23/2015
      6/25/20142/25/2015
      7/8/20143/6/2015
      4/11/20143/10/2015
      11/21/20133/17/2015
      6/27/20144/15/2015
      5/12/20144/29/2015
      6/27/20145/27/2015
      4/30/20136/22/2015
      11/5/20147/2/2015
      12/17/20147/7/2015
      7/11/20147/10/2015
      11/24/20147/24/2015
      3/31/20147/24/2015
      9/26/20147/24/2015
      10/27/20098/18/2015
      8/27/20148/27/2015
      9/5/20149/1/2015
      1/8/20159/4/2015
      11/19/20129/17/2015
      12/19/20149/22/2015
      9/29/20119/25/2015
      9/29/20119/25/2015
      8/22/201410/5/2015
      2/19/201510/16/2015
      10/21/201410/21/2015
      12/23/201410/23/2015
      11/19/200810/23/2015
      11/4/201411/4/2015
      11/5/201411/5/2015
      12/11/201411/10/2015
      6/5/201511/13/2015
      7/9/201511/16/2015
      7/10/201511/20/2015
      12/2/201411/24/2015
      6/29/201511/30/2015
      1/8/201512/8/2015
      7/6/201512/11/2015
      10/31/200712/15/2015
      12/22/201412/21/2015
      12/29/201412/22/2015
      5/28/20151/28/2016
      11/20/20142/18/2016
      3/20/20153/18/2016
      3/23/20153/22/2016
      3/30/20153/23/2016
      7/31/20153/30/2016
      10/29/20154/11/2016
      9/1/20154/29/2016
      1/12/20165/18/2016
      2/27/20155/27/2016
      9/28/20155/27/2016
      6/29/20155/27/2016
      7/1/20156/1/2016
      10/28/20156/28/2016
      2/25/20157/11/2016
      7/27/20157/27/2016
      6/26/20159/19/2016
      2/24/201610/19/2016
      11/23/201510/21/2016
      1/7/201612/14/2016
      6/23/201612/19/2016
      9/23/201612/23/2016
      1/29/20161/19/2017
      8/24/20152/7/2017
      6/9/20162/9/2017
      11/16/20152/15/2017
      3/30/20162/28/2017
      8/29/20163/13/2017
      12/29/20143/21/2017
      9/23/20163/23/2017
      3/23/20163/23/2017
      10/31/20163/27/2017
      7/29/20163/28/2017
      4/28/20163/28/2017
      5/29/20154/3/2017
      8/11/20164/11/2017
      5/27/20164/27/2017
      3/30/20164/28/2017
      8/29/20164/28/2017
      8/29/20164/28/2017
      10/13/20165/1/2017
      6/16/20165/5/2017
      10/30/20155/22/2017
      10/19/20166/19/2017
      10/24/20166/23/2017
      11/16/20167/13/2017
      7/19/20167/17/2017
      12/8/20167/18/2017
      12/30/20168/1/2017
      12/14/20168/3/2017
      12/20/20168/17/2017
      12/29/20158/29/2017
      12/29/20168/29/2017