-
1. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
lei.chen.0Mar 6, 2017 6:16 PM (in response to sam.hong.0)
Hello sam,
The attached workbook might meet your request 1.
I also made some changes to your existing calculations, including add IFNULL to your event counts, and [SHAPE: Change].
I still left the NULL for [YEAR: Change] for it's divided by zero.
And a question for request 2.
Do you want to compare month/quarter with last month/quarter or with the same month/quarter of the previous year?
Regards
Lei
-
Tableau Data - Mapping.twbx 144.7 KB
-
-
2. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
sam.hong.0 Mar 7, 2017 6:06 AM (in response to lei.chen.0)Lei,
Thank you!!! Request one was exactly what I was hoping for!
And for Request 2, I would ideally like to be able to compare Current Quarter to Last Quarter (Q1 2017 vs Q4 2016) and also Current Month to Last Month (March 2017 vs. February 2017).
However, if you also happen to know how to do this for the same quarter and month in the previous year, that is more than welcome as well!
Sam
-
3. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
lei.chen.0Mar 7, 2017 9:16 PM (in response to sam.hong.0)
Hello Sam,
Happy to hear that
I suppose the four variations of comparisons are all possible, with more calculated fields.
Sorry that I may not have enough time for this today.
Please wait a while.
Regards
Lei
-
4. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
sam.hong.0 Mar 8, 2017 6:05 AM (in response to lei.chen.0)Thank you, Lei!
Looking forward to it!
-
5. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
lei.chen.0Mar 9, 2017 10:24 PM (in response to sam.hong.0)
Hello SAM,
Sorry for having kept you waiting.
I'm back with the attached sample workbook.
Now we have three parameters.
Parameter 1. Select Comparison by
Choices are,
- Year
- Quarter
- Month
- Quarter vs Last Year
- Month vs Last Year
Parameter 2. Select Year
When "Year" is selected in Parameter 1, this parameter works.
Parameter 3. Select Year-Quarter
When "Month" or "Month vs Last Year" are selected in Parameter 1, this parameter works.
I've prepared everything ready for "Year", "Quarter" and "Quarter vs Last Year" in Parameter 1.
Please check the results.
Then here comes your homework.
Please give it a try at setting up "Month" and "Month vs Last Year" and enjoy the process
Please feel free to ask if there's any question.
Regards
Lei
-
Tableau Data - Mapping.twbx 149.1 KB
-
6. Re: Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)
sam.hong.0 Mar 13, 2017 7:07 AM (in response to lei.chen.0)Hello Lei,
Sorry for the late response but thank you so much for looking into this and providing the steps needed for me to figure out how to do the month based on what you created. I am going to work on it this week and let you know if I have any questions!
Sam