-
15. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 6, 2018 8:53 AM (in response to Gerardo Varela)Hi Gerardo,
I have come across one issue with sub totals when used WINDOW_MIN(MIN([Pname]))=WINDOW_MAX( MAX([Pname])). Sum got greyed out in Total using calculation in swap measures and dont have any control on it. Results are incorrect when i select single Pname only.
If i use MIN([Pname]))=MAX([Pname])), it works fine and have ability to control the subtotals such as Sum/Avg/Min/Max etc. But my logic fails if i use this Min/Max logic.
Any suggestions , please!
Thanks,
Ashok.
-
16. Re: Swap the measures based on Actions dynamically
Gerardo Varela Apr 6, 2018 12:00 PM (in response to Ashok Ramineni)Hi Ashok,
Can you post your packaged workbook? I don't really understand from the screen shot you provided. Can you also tell me the expected results?
Regards,
Gerardo
-
17. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 6, 2018 12:26 PM (in response to Gerardo Varela)PFA.
I am using the most recent workbook which has been modified by you.
Please look at the dashboard 1.
Expected Results:
When Pname=OTHER is selected, should display the results as highlighted in yellow in the swap measures along Name, Type measures.(I have created Results field for your reference)
Values are displaying correctly, but not the subtotals and grand totals in column 1.
When more than 1 Pname is selected or none of the Pname is selected, the field highlighted in yellow should hold the existing logic , which is working properly.
Subtotals & Totals are working fine for this scenario.
Thanks!
-
18. Re: Swap the measures based on Actions dynamically
Gerardo Varela Apr 6, 2018 1:54 PM (in response to Ashok Ramineni)Hi Ashok,
I believe the attached solves your question above.
Regards,
Gerardo
-
19. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 8, 2018 8:56 PM (in response to Gerardo Varela)Hi Gerardo,
Seems like everything is working fine except one case. I do have other quick filters as shown.
When I select a value from Dname, then results in GV Swap Measure are incorrect. Expected results should be as shown in column1(Green box). Column1 is retrieving correct results for all filter conditions except Sub-Totals.
I tried to include Dname & Month in the LOD and worked fine for this filter criteria, but whichever worked for other filter criteria getting failed. Please advice.
However when i select all other values from Market/Month/Single or multi select on dname, results are correct. PFA workbook.
Thanks!
-
Actions_10.5.twbx 64.6 KB
-
-
20. Re: Swap the measures based on Actions dynamically
Gerardo Varela Apr 9, 2018 7:08 AM (in response to Ashok Ramineni)Hi Ashok,
I'm thinking you need to add your dimensions to the LOD calculation. Either that or setting all your filters to context. See attached.
Regards,
Gerardo
-
Actions_10.5gv266083vs4.twbx 67.4 KB
-
-
21. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 9, 2018 7:39 AM (in response to Gerardo Varela) -
22. Re: Swap the measures based on Actions dynamically
Gerardo Varela Apr 9, 2018 9:42 AM (in response to Ashok Ramineni)1 of 1 people found this helpfulHi Ashok,
Since your adding and removing dimensions try changing the LOD to:
{INCLUDE :SUM(Sales)/SUM([Qty])}
But I'm not 100% sure if that is the expected outcome since your data set has changed since the initial question.
Regards,
Gerardo
-
23. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 9, 2018 1:54 PM (in response to Gerardo Varela)Great Gerardo.. Looks good so far and will let you know for any issues.
Appreciate your help...!!!!
-
24. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 10, 2018 8:48 PM (in response to Gerardo Varela)Hi Gerardo,
I have encountered small issue in grand total % as highlighted in Red color and even works for multi select or no select on Dname, but not on single select.
% logic: column3/Column1 i.e. (298.2/954.2)*100=31.25% is the expected results and this functionality should happen irrespective of any filters. PFA workbook for your reference.
Thanks!
-
Actions_10.5.twbx 31.9 KB
-
-
25. Re: Swap the measures based on Actions dynamically
Gerardo Varela Apr 11, 2018 7:12 AM (in response to Ashok Ramineni)Hi Ashok,
I think you ought to post a a new question. We've had a tad bit of scope creep already.
Regards,
Gerardo
-
26. Re: Swap the measures based on Actions dynamically
Ashok Ramineni Apr 11, 2018 8:38 AM (in response to Gerardo Varela)Sure Gerardo,
As suggested, I have posted a new a new question. below is the link for your reference. Please look into it when your time permits.
https://community.tableau.com/message/749503#749503
Thanks in advance.