Document Property in Prepared Report Header doesn't change with filter.

[Ruby Chang]

I created a calculated value, which shows the number of unique id in the analysis, and connected it to a document property called "WellNum". When I create the prepared report, I want the analysis to repeat over based on one column, and show ${Report.Filter} - ${WellNum}in the header.

However, ${WellNum} keeps the same as the total number of id, not the number of ids for each filter. I don't know how to make it change for each page based on filter. Thanks in advance.

[Fredrik Rosell]

Hello,

Having tested this quickly, I believe I understand what you are trying to achieve, and also believe that this is not possible to achieve today within a prepared report (I e.g. did a test using the Custom DateTime function - https://community.spotfire.com/s/article/Custom-DateTime-Data-Function-for-TIBCO-Spotfire - attempting to update the document property for each filter value, but that did not help).

However, it would help if you could provide a copy of your analysis to see how you currently have this configured.