Batch Macro and Filter Functions

Question

Hi,

I am attempting to develop a batch macro function that allows a user to enter text which would in turn update the criteria of a filter within the macro. I have attached a screenshot of the macro I am attempting to run. I was just curious as to whether anybody knows how to get this function to work where the macro is input into a regular workflow, the user can enter a value (in this case, a 5-character value) that does an initial filter of the data and then a second value (same format as before) which then does a second filter later in the workflow.

In this case, it is for medical billing where we are trying to first identify an initial population of claims based on the primary procedure code and then trying to determine how frequently a specific secondary procedure is billed with the primary procedure on the same patient claim.

Here is a screenshot of the what I am attempting to run below:

Thanks!

Jeff

MarqueeCrew · Accepted Answer

@jbuzzotta,

Jeff, Jeff, Jeff.  I encourage you to consider options to the ask.  In looking at the picture of your workflow I see that both filters look at [CPT].  I imagine that a claim (or billing) has an ID field with many rows of data.  I might create a table of all combination of procedure codes and use that for analysis.  If you opt to go with your existing macro, I think that you will have success in a Standard Macro.  Simply update the filter for CPT values from 2 questions.

Here is a picture of the analysis file that I am suggesting:

I'm happy to help you in finishing off your macro if you want to do that.  If you post the file of the macro, I'll take a look at it.

Cheers,

Mark

jbuzzotta · Accepted Answer

Hi Mark-

Sorry for the delay in the response, I was working through your solution.

This appears to be what we were looking for and are still currently working a flow based on what you suggested. If we run into any further issues I'll let you know.

Thanks for taking the time to help with this issue!

Best,

Jeff