were you able to find a solution for this?
Janet, I am also looking for any information regarding the ability to create custom calendars (either now or in a planned future release). We have a fiscal calendar (4/4/5) throughout the year so our calendar month-end never matches our fiscal month-end (except on 31 Dec). I've searched the KB and only found reference to where you can alter the fiscal *year*-end but that's it.
FYI, i am still new with Tableau and we are still evaluating the product so i could be wrong here.
My work around is I created a table with all the dates and the corresponding month, quarter, year etc for us and this is what i join to my measures table. And so this works for generating reports but because i am using the Date field here instead of the measures table's date, i cannot use the trending feature. the trending feature apparently wants me to use the original date field which will use the calendar year, quarter, month instead.
Date Month PERIOD_YEAR PERIOD_NUM QUARTER_NUM PERIOD_NAME YEAR_START_DATE QUARTER_START_DATE Current_Ytd_Flag Previous_Ytd_Flag Current_Qtd_Flag Current_Mtd_Flag 5/24/2007 May 2007 5 2 MAY-07 1/1/2007 4/1/2007 N N N N 1/1/2007 Jan 2007 1 1 JAN-07 1/1/2007 1/1/2007 N N N
I would love to see an answer to this. As far as I can tell, the only way to create a line chart is with an actual date field. We have date fields but it wants to create a simple calendar hierarchy. We have our own fiscal calendar dimension but fiscal year/quarter/week aren't date data types so they can't be used on a line chart.
We are doing some on-site training in a few weeks and this will be the first question we ask because if we can't create a line chart with our own fiscal calendar it's going to turn out to be a pretty big problem. If this hasn't been answered by then I'll post the answer we get at the training.
A date dimension is not required to draw a line chart in Tableau. This is a common misconception, most likely due to the "Show Me" window tells us to use a date dimension for a line chart. However, other discrete dimensions (blue dimension pill) can be used as well--see the screenshot below (my Week # field is pre-defined in the data source):
Changing the options on the marks shelf will yield results beyond what Show Me! suggests, so I'd encourage exploration with that. Studying the workbooks of others is helpful in seeing different approaches.
Thank you. As a first time user creating a line chart by changing the "Marks" drop down is non-obvious. Using the Show Me picker seems, on the surface, like the only way to do it. I am now able to see the chart I was hoping to see.
Great! I agree, it is non-obvious when getting started. Unfortunately, a lot of Tableau seems to be non-obvious once you get outside of the basics. Still, a great and powerful tool worthy of learning, I think.