Thanks for the video - it is helpful. I am trying to show month-over-month change in value for an item # as 3 measures columns: Month1, Month2, and Difference. I've played around with a few different approaches (including from this video); the difficulty I am having is that when I am able to show 'Difference' as it's own column, it displays an 'extra' blank column under Month1 (which is essentially trying to show the difference between Month1 and Month0)...is there a different approach to force the viz to show 3 columns or how can I hide this blank column?
Sorry for the late reply, I was on vacation. You probably figured it out by now, but there is a "Hide" function for columns. I'm not sure it would work with table calculations. If you had a list of years, you could hide a year and the calculation would still work..
Can you please make a video on how to create six time periods out of a year similar to 4 quarters. Tableau's "date field" by default expands into year, 4 Qtrs and 12 months when you keep a date field in the shelf. Can I make the same field to display 6 time periods similar to 4Qtrs. This will help me with Pair over Pair similar to Quarter over quarter or month over month trends/ calcs. A pair of mths could be P1=Jan & Feb, p2=Mar & Apr like that until P6 =Nov & Dec. I need this "period field " exactly like a DATE FIELD with all its features. Say for ex when i keep this newly created field in the column shelf, it should roll out as year, Qtr, Set (Pair of mths), and then Day. With this I can do a period over period analysis like quarter over quarter. THANK YOU!!
Thanks for the video - it is helpful.
I am trying to show month-over-month change in value for an item # as 3 measures columns: Month1, Month2, and Difference. I've played around with a few different approaches (including from this video); the difficulty I am having is that when I am able to show 'Difference' as it's own column, it displays an 'extra' blank column under Month1 (which is essentially trying to show the difference between Month1 and Month0)...is there a different approach to force the viz to show 3 columns or how can I hide this blank column?
Sorry for the late reply, I was on vacation. You probably figured it out by now, but there is a "Hide" function for columns. I'm not sure it would work with table calculations. If you had a list of years, you could hide a year and the calculation would still work..
Hi Weston, I am looking for a way in which we can create a table for average appointment volume by quarters for 2 years.
Can you please make a video on how to create six time periods out of a year similar to 4 quarters. Tableau's "date field" by default expands into year, 4 Qtrs and 12 months when you keep a date field in the shelf. Can I make the same field to display 6 time periods similar to 4Qtrs. This will help me with Pair over Pair similar to Quarter over quarter or month over month trends/ calcs. A pair of mths could be P1=Jan & Feb, p2=Mar & Apr like that until P6 =Nov & Dec. I need this "period field " exactly like a DATE FIELD with all its features. Say for ex when i keep this newly created field in the column shelf, it should roll out as year, Qtr, Set (Pair of mths), and then Day. With this I can do a period over period analysis like quarter over quarter. THANK YOU!!
Another viewer made the same request. Maybe your the same person? :)
Wow what an amazing tutorial. How would I do Month over month change that has a month not in the view. Thanks
Thanks for the question. Why is the "month not in the view"? Is there no data?
That was Fantastic - THANK YOU !!!
Thank You! You are an Angel!!!!
Thank you great and super explanation
Glad it helped. Thanks for watching. Hope you subscribed. :)
Excellent
Glad you liked it. I have some other related videos. Search for Year over Year, and custom date ranges.
Great Explanation
Glad it was helpful!