4 Replies Latest reply on Oct 10, 2016 10:04 AM by Andrew Lloyd

    How to use Integer Fiscal Periods Instead of Dates?

    Andrew Lloyd

      I am having trouble figuring out how to display data over time using integer fiscal periods instead of actual dates. For example, let's say I want to show Revenue over time using a line chart. Instead of dates, I have the following integer fields: FiscalYr, FiscalQrt, FiscalMth, and FiscalWk. I can show the breakdown by Fiscalwk without any issue if I am using Text Tables, but I am unable to se the data over time b/c Tableau doesn't understand that these are sequential.

       

      I can't just change the Fiscal Year Start because our fiscal months don't follow the calendar months exactly. Thoughts?