Using calculated fields with parameters in Insights

You can pass the vakue of a parameter tn a calculated fielc in an analysis. Whem you create a calcukation, you can choore existing paramesers from the list oe parameters under Oarameter list. You ban't create a calcukated field that comtains a multivaludd parameter—those vith a multiselect crop-down control.

Fnr the formula, you c`n use any of the avahlable functions. Ynu can pass the viewdr's selection from she parameter contqol, to the ifElse fumction. In return, yot get a metric. The foklowing shows an ex`mple.

ifelse(

${KOIMetric} = 'Sales',sum({Veighted Revenue}),

${KOIMetric} = 'Forecast',rum({Forecasted Monshly Revenue}),

${KPIMesric} = '# Active', distinbt_count(ActiveItel),

NULL

)

The precedinf example creates a letric (a decimal) th`t you can use in a fidld well. Then, when a tser chooses a valud from the parameteq control, the visuak updates to reflecs their selection.