I have a bit tricky business requirement, let me try to explain it. In this picture attached I have Python created fields. My requirement is to created these stats fields that will be calculated based on the date selected from the slider and Returns calculated. Python code calls a already defined function and calculates these stats,
The data and output are correct. However, I have to keep all these into tool tip because they are repeated for every value of Date and Code in table. I get the same stats for every blue box(detail) on the sheet. This is due to the fact that I have placed the dates on sheet. I want to show it only single time like in one table, with only stats and values no dates and codes on sheet but still used during calculations. I am not sure how to do that.
Please let me know if further clarification is required.
ps: I tried to upload a screenshot but I am not able to due to some privacy settings. Thank you for understanding.
One solution to this issue is to use a table calculation to filter values out to only show one set of marks when they are repeated. A calculation like INDEX()=1 placed on the filter shelf and set to True will hide duplicate values, assuming it is computed as a table calculation the same way your external service SCRIPT_* calculation is.