-
1. Re: Sort view by Last 2 weeks sales difference
Don Wise Dec 25, 2018 10:45 AM (in response to Prasad N)Hi Prasad,
Please see attached 10.2 workbook; lowest versioning that we can go for exporting version as (hopefully opens for you). Please follow along:
Changed [Curr Week Sales] to a Fixed LOD:
Did the same thing for [Previ Week Sales]:
Changed [Sales Diff] to the following (needed to use SUM and ROUND):
Then selected Sub-Category pill and clicked on Sort:
A new dialog box opens. Use the drop-down and selected sort on [Sales Diff]:
Sort order is now High-to-Low based on Sales Difference for most current week:
-
Sort by Calculated Field_v10.2.twbx 406.6 KB
-
-
2. Re: Sort view by Last 2 weeks sales difference
Prasad N Dec 26, 2018 12:29 PM (in response to Don Wise)Hi Don Wise,
your idea Calculating diff is working.
But there is a concern with Latest Week parameter value. When data is updated, a new week added but parameter values is not refreshed to latest data.
How to we set dynamically refresh parameter to latest date from the date filed. ? or select max/latest date from date column/filed ? so that latest week value can be referenced in calculations.
Thanks
-
Sort by Calculated Field_v10.2.twbx 447.4 KB
-
-
3. Re: Sort view by Last 2 weeks sales difference
Don Wise Dec 26, 2018 2:03 PM (in response to Prasad N)Hi Prasad,
Currently, as far as I know, there's no ability to 'dynamically' update your parameter control to 'Today' or to use the TODAY() function for latest date in the parameter settings. Parameters are static. A workaround would be to Edit your Parameter and set it for a date far into the future so that as new data arrives, it should recognize and display the updated data accordingly. Hope that helps.
I think the original question was answered here as well, so please close the thread by marking as correct. Thx! Don
-
4. Re: Sort view by Last 2 weeks sales difference
Prasad N Dec 27, 2018 8:04 AM (in response to Don Wise)Hi Don,
Is there any way instead of opening workbook every week ? I want to automate the updating latest date in workbook, Once workbook is published.
Thanks,
PN