1 Reply Latest reply on Dec 12, 2018 9:58 AM by Nathan Mannheimer

    Python table calculation

    Neha Tharani

      Hello all,

       

      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.

        • 1. Re: Python table calculation
          Nathan Mannheimer

          Hi Neha,

           

          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.

           

          Sincerely,

          Nathan