
1. Re: Product function (Excel) on Tableau, and Time series analysis
Mahfooj Khan Mar 25, 2019 11:44 PM (in response to Ben K)Hi,
Is that what you were looking for?
Workbook attached for your reference. Let us know if you've any question.
Mahfooj

PRODUCT FUNCTION_v10.2.twbx 30.8 KB


2. Re: Product function (Excel) on Tableau, and Time series analysis
Ben K Mar 26, 2019 7:42 PM (in response to Mahfooj Khan)1 of 1 people found this helpfulHi, Mahfooj
This is great! Thank you for your solution.
I honestly have one more step to calculate after that, which is Exist * PRODUCT() and Exist * PRODUCT()/12.
So It will be prefect If I can have all same PRODUCT() value for every TERM(month) instead of a PRODUCT() at the end of each TERM(month). This can be happened?
Again, great job Mahfooj!

3. Re: Product function (Excel) on Tableau, and Time series analysis
Mahfooj Khan Mar 26, 2019 9:06 PM (in response to Ben K)Here you go Ben!
Hope this will serve the purpose. Kindly mark helpful/correct on my replies if it helps you to achieve the correct output.
Mahfooj

PRODUCT FUNCTION_v10.2.1.twbx 31.1 KB


4. Re: Product function (Excel) on Tableau, and Time series analysis
Ben K Mar 26, 2019 10:51 PM (in response to Mahfooj Khan)1 of 1 people found this helpfulJesus, you are amazing!
I can't not say how thank I am.
I appreciate your help

5. Re: Product function (Excel) on Tableau, and Time series analysis
Mahfooj Khan Mar 26, 2019 11:00 PM (in response to Ben K)1 of 1 people found this helpfulYou're welcome
Thanks for your kind words!

6. Re: Product function (Excel) on Tableau, and Time series analysis
Ben K Apr 11, 2019 2:25 AM (in response to Ben K)Hi Mahfooj,
hope you are well.
I know I already got lots of help from you but stuck again.
I was asked to fold up or take the TERM(month) out of the table view with keeping the value of "1Product()" for TERM(year).
I have tried some way such as combined filed or hierarchy already. Since the Product() and 1  Product() measure work with TERM(Month), it pops out as error marks for both Product() and 1 Product() marks.
The table I am looking for looks like under:
Thanks for your contribution.
Sincerely,

7. Re: Product function (Excel) on Tableau, and Time series analysis
Mahfooj Khan Apr 15, 2019 1:46 AM (in response to Ben K)Hi Ben,
I'm doing good. Not very active in community these days due to some other priority works
However, I have got chance to look into your issue and this is what I have got. Hope this will help. Take a look.
Mahfooj

PRODUCT FUNCTION_v10.2.twbx 33.7 KB


8. Re: Product function (Excel) on Tableau, and Time series analysis
Ben K Apr 15, 2019 5:11 PM (in response to Mahfooj Khan)Mahfooj, hope they went well.
Jesus, you are literally amazing!
I was not sure this can be solved this time while I was uploading this question.
Great thanks to you

9. Re: Product function (Excel) on Tableau, and Time series analysis
Mahfooj Khan Apr 15, 2019 9:03 PM (in response to Ben K)Welcome Ben! Yeah it was manageable
Glad I could help.
Mahfooj