-
1. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 18, 2018 2:19 PM (in response to Samanth Yadav)
-
Quarter_calc_SM_10.2.twbx 39.7 KB
-
-
2. Re: Month and Quarter Calculations?
Samanth Yadav Jan 18, 2018 10:01 PM (in response to Shinichiro Murakami)Hi Shinichiro,
Thanks for the response. Yes it does help. But, lets say if we have both the Beginning and Ending Balance for a Date. How should we write the Quarter Calculation and is it possible to provide the user with a single filter or parameter to show both the Months and Quarters of an year/s so that they can pick month or quarter as per there requirement
Example:
2016 Jan
2016 Feb
2016 March
2016 Q1
2016 Apr
2016 May
2016 June
2016 Q2
.......
Please find the attached image with Beginning and Ending Balance for a Date.
Thank you.
-
3. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 18, 2018 10:14 PM (in response to Samanth Yadav)
Hi Samanth
Your requesting feature is not very clear to me.
Which user's behavior should bring what?
And what should be shown on table?
Could you illustrate with hand drawing or something more clearly?
Thanks,
Shin
-
4. Re: Month and Quarter Calculations?
Samanth Yadav Jan 19, 2018 1:31 AM (in response to Shinichiro Murakami)Hi Shinichiro,
My first question, if we get both the Beginning and Ending Balance for a Date field from the query. How should we write the Calculation to get the Beginning and Ending Balance of a Quarter in Tableau.
For example:
Date Ending Value Beginning Value
2017-1-31 10000 0
2017-2-28 10100 10000
2017-3-31 10200 10100
2017-4-30 10300 10200
2017-5-31 10400 10300
2017-6-30 10500 10400
Second Question, As we are showing both month and quarter beginning and ending Balance on a dashboard.
Is it possible to provide a dropdown Date filter which can give an option to select by either month or quarter of a year/s
Please see the attached Images for month/year and quarters filter.
Can we provide a single date filter which has options to select 2017 Jan if they want to see Jan month data or 2017 Q1 if they want to see Quarter 1 data of 2017. Is there any work around in Tableau?
Thank you.
-
5. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 19, 2018 2:01 PM (in response to Samanth Yadav)
-
Quarter_calc_SM_10.2_v2.twbx 62.1 KB
-
-
6. Re: Month and Quarter Calculations?
Samanth Yadav Jan 19, 2018 2:54 PM (in response to Shinichiro Murakami)Hi Shinichiro,
You the Man. Thanks a lot.
Need one last help. I'm attaching my sample workbook. Can you please do the calculations in the attached workbook and reattach the file back so that i can understand without doing union of sheets as I'm getting the data from database.
Thank you.
Regards,
Samanth
-
Sample Data M-Q.twbx 15.6 KB
-
-
7. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 19, 2018 4:52 PM (in response to Samanth Yadav)
Hi Samanth,
See attached.
Please mark my answer as correct / helpful to close the thread.
Not from inbox view but from original post.
Thanks,
Shin
-
Sample Data M-Q_SM_10.2.twbx 17.6 KB
-
-
8. Re: Month and Quarter Calculations?
Samanth Yadav Jan 19, 2018 5:22 PM (in response to Shinichiro Murakami)Thanks a lot Shinichiro .
-
9. Re: Month and Quarter Calculations?
Samanth Yadav Jan 23, 2018 1:28 PM (in response to Shinichiro Murakami)Hi Shinichiro,
Need Small help. Please see the attached images.
Question 1) Is it possible when we select the month/quarter filter (ex: 201711 or 2017Q1) to show the entire portfolio balance(i.e; the Ending FV) for the 2017 year for all the months?
Right now I'm using a separate filter for the Portfolio Balance. Is it possible to use only month/quarter filter which works for both the sheets.
Question 2) For the segment premium wine, if I select the 2016 Q3 or 2017 Q1 the End Balance shows as Null. Is there any way we can change the calculation for the Quarter, let's say for 2016 Q3 the End balance should be as of September. But as we don't have any premium wine Value for September can we show the End balance as of August for 2016 Q3 as we have the end balance for August 2016. Similarly, for 2017 Q1 the End balance should be as of March. But as we don't have any premium wine Value for February and March can we show the End balance as of January for 2017 Q1 as we have the end balance for January 2017.
Attached the workbook.
Thank you.
-
Sample Data.twbx 51.0 KB
-
-
10. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 23, 2018 4:01 PM (in response to Samanth Yadav)
Hi Samanth
It is getting confusing me and request is already very different from original.
Could you please post another thread.
Thanks,
Shin
-
11. Re: Month and Quarter Calculations?
Samanth Yadav Jan 23, 2018 4:47 PM (in response to Shinichiro Murakami)Hi Shinichiro,
Here is the link to the new post thread. It would be great if you can help me out on this.
Thank you.
Quarter Calculation and using a single filter for two different sheets?
-
12. Re: Month and Quarter Calculations?
Shinichiro MurakamiJan 23, 2018 7:25 PM (in response to Samanth Yadav)
Added reply.
Shin