Analytics Edge Macro – you can ONLY select from Analytics Edge macros that start with an underscore (e.g. “_setup”). These macros will NOT run when you click the Refresh All button, nor during a Scheduled Refresh. They can only be run manually or when called by this function.
If you are a programmer, you can think of these underscore-named macros as subroutines or methods. Note that each macro starts ‘clean’, knowing nothing about the macro that called it, so you need to pass values through a worksheet — one macro writes to a worksheet and the next macro reads the values it needs from that worksheet.
Excel VBA Macro – this option lets you run an Excel VBA macro as part of an Analytics Edge refresh.
Windows Command – this options lets you run Windows programs as part of your Analytics Edge macro. Note: to run a Windows command, use the filename cmd.exe and start the arguments with /C so the command window will run and terminate.
Set criteria to determine if the macro/command will be run or not. At least one row in the current data must pass all of the criteria.
Column – select a column by column letter position (optionally by Name).
Criteria – select a filter criteria or test to use.
Value – enter a value to use for the filter test. For text columns, optionally check Case sensitive to match upper and lower case letter exactly.
AND – add the filter rules (Column, Criteria and Value) to the list using AND logic, meaning both this rule in addition to a previous rule entered are required to cause a match.
OR – add the filter rules (Column, Criteria and Value) to the list using OR logic, meaning either this rule or a previous rule entered will cause a match.
Updated for v10.