How to create fixed value KPIs?

[santho_ak]

Hi,

     I need to create a static KPI, where I need to display Avg salary of a comapny. It should be calculated from  the data connection & it should not alter based on any selection.  Is there any way

Help me out.

Thanks

[petter · Accepted solution]

Set Expressions are made for exactly the purpose of overriding or modifying the current selection.

You should be able to calculate your average salary like this:

Avg( {1} Salary )

[petter]

Hi Santhoh,

If this answered your question please mark the question as answered so we can close this thread.

regards

Petter