KPI problems

[Anonymous]

Hi,

I have created a measure that tells me wether the assigment is insured or not with the following function: (StandardInsured = '1' or Household='1')

Now I would like to create a KPI using this measure, where the KPI tells me how many % of the chosen assignments that are insured. I tried with the following formunal for the KPI: count(StandardInsured = '1' or Household='1')/count(AssignmentNo)

But this does not give me a correct value.

Does anyone have any ideas on how to solve this?

Thanks!

[marcus_sommer · Accepted solution]

I think it should look more like:

count({< StandardInsured = {1}, Household = {1}>} AssignmentNo) / count(AssignmentNo)

with the assumption that your flags are numeric and not strings (which will be require the single-quotes like '1').

- Marcus

[Anonymous]

Thank you, that looks right.

Now I get a count on the assignments that are both standard insured and household.

How would I write if I want to count the assignments that are either standard insured or household?

Thanks in advance

[sunny_talwar]

Try this:

Count({<StandardInsured = {1}>+<Household = {1}>} AssignmentNo)/Count(AssignmentNo)

[Anonymous]

Hi,

I tried but I still get a very low % and I think it's because the expression is showing assignments that have both these conditions. I'm looking for assignments that have either or.

Do you have any suggestion on how to get this?

[sunny_talwar]

You can always try this:

RangeSum(Count({<StandardInsured = {1}>} AssignmentNo), Count({<Household = {1}>} AssignmentNo))/Count(AssignmentNo)

[Anonymous]

Thank you, that looks better.

I have also created a dimension that I want to use in a table to show which assignments that are insured or not.

Currently I have the following expression: (StandardInsured = '1' or Household='1')

How can I change this to the better?

Also, right now this gives me a zero for when there's no insurance and -1 when there is insurance. Can I change this to true/false somehow?

[sunny_talwar]

This dimension is created in the script or is this a calculated dimension? Can you elaborate a little.

Also, just as a suggestion for future request, I would suggest creating a new thread for new requirement. This way your question will get more exposure + it will be helpful for people using these in the future.

Best,

Sunny

[Anonymous]

I have written it in the script for creating a new dimension.

Here's the result: