
1. Re: LOD Expression and Binning of Categorical Value
Zhouyi Zhang Jan 1, 2018 6:08 AM (in response to Lihos G)Hi, Lihos
I hope I understand your requirement, below find attached workbook with my solution.
Below is the screenshot of steps and results.
Update: forget to mention, I made changes to % calculation as well
Hope this could help
ZZ

Tableau_LAS_MIS_POC_v1.twbx 1.8 MB


2. Re: LOD Expression and Binning of Categorical Value
Lihos G Jan 2, 2018 3:03 AM (in response to Zhouyi Zhang)Hey ZZ,
This is exactly what I was looking for, Really appreciate your help thanks. I was thinking, since I have Already used LOD expression in Calculation LatestBooksize_RM, Latest_Booksize_Category_% would not Require using LOD again. I Still need to understand LOD expressions I guess.
I have one more follow up Question.
I am trying to calculate Difference of LatestBooksize_RM and Booksize value selected by Parameter control which is as follows:
User inputs number of days and I have to calculate date difference from Latest date and accordingly calculate Difference in Booksize.
Marked in red is the same calculation used to calculate LatestBooksize_RM.
I am able to get Difference Date by taking number of days as input in below screenshot.
( variable marked by red arrow is just to test date difference calculation).But I am not able to get the difference in Booksize.I am not sure what I am doing wrong.

3. Re: LOD Expression and Binning of Categorical Value
Lihos G Jan 2, 2018 9:55 PM (in response to Lihos G)