Hi everyone,
I've hit a snag in an analytics app I'm building.
- Currently the app brings in a full account set (eg. 80,000 records)
- I have the user appending in a quantity of samples they'd like to see; and I'm passing the data through into another field (eg. 10 samples).
- A formula tool is updated to calculate how many samples will pass into my sample tool (80,000 / 10) = Random 1 in 8000 Chance for each record.
- I'm trying to pass the calculated 8000 values into my sample tool.
To do this, I'm assuming I'd pass the tool somehow out of my workflow, then back into the connecting sample tool.
I'm having a problem though; I don't know how to store a values to be passed from tool to tool. I'm assuming I'm doing something wrong here.
I don't want the user to have to enter the N value to be passed into the sample tool, as the 80,000 input quantity hugely varies depending on the sampled file they're looking at (eg. some files are 2,000 records, and some are 500,000 records); and the user doesn't know.. I don't want them to have to keep guessing at how many total records are passed in the file to make this decision, which is why I'm calculating the N value for them based off how many accounts they want to see.
Thank you,
James
