I've defined some values using a formula tool on the "Days Pending(Prop)" column and output them into an "Aging Bucket" column. I've hardcoded five values, with others set to NA.
Later, I use a cross-tab tool to convert these values into columns and then apply a summary tool.
The issue is that the "Days Pending(Prop)" column doesn't always contain the five hardcoded values. I need the summary tool to be dynamic, adapting to the available data.
Is it possible to achieve this? Could you demonstrate a proof of concept?
@Jules22
It is possible to make it dynamic however that would be a more complex solution. What you can do ensure that you always going to have all the 5 elements and if one is not reported then have zeros for that element.
If you want to do it fully dynamic, you can do it by changing the XML data for the Summarize tool, sending it into a Batch Macro and update the XML to the available fields. So yes, it is possible.
Hi @Jules22. This may be a scenario for you to create a batch macro. Check out this article to find out more about batch macros and how they might help. Getting Started with Batch Macros (alteryx.com)
Can you demonstrate a small poc?