This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's a workflow that answers the 1st part of your question, "Given a set of columns what KPIs can I calculate?"
The top input is your list of KPIs which gets transposed to put the 3 requirements into one column. The bottom input is your data, which in my case has the columns Total Spend, Impressions and Conversions. The Field Info tool extracts the list of columns from your data. This is joined with the transposed KPI data on column name. The summarize tool count the columns available for each possible KPI and the filter passes only the KPIs with 2 columns available.
I'll leave the second answer to you, but post back here if you run into any issues and we'll see if we can help some more.
For an example using _CurrentFieldName_ ..... Check out the Multi-Field Formula tool example. On the left, under the Current Field tree, you'll see 3 options for _CurrentField_ and _CurrentFieldName_ and _CurrentFieldType_
I'm also guessing that your field names in the expression need to be enclosed in brackets.
Note the single quote followed by double quote, and double quote forllowed by single quote in this text: '"+[KPI]+"'
This will grab the value from the KPI field and place it inside single quotes.