Count() issue in combination with business calculation as a condition

Ask the Community
1

So im running into some inconsistancy issues and for the life of me i cant seem to figure out what i did wrong.

What im trying to achieve:
A singular number to show the amount of customers in a certain stage of our customer journey. Since we work with multiple installers, im looking for multiple stage ID’s which all basicly mean the same thing. To make this happen i created a business calculation as a condition which has to be true.

Tried it 2 ways, with an OR functions and a case when function. Both seem to work good as a condtion. As when i look at the raw data in a table, theres 85 unique entries. Which is the exact amount of customers currently in this stage.

However: for a KPI view you’d ofcourse need a number. So what i usually do is count(id) to count the total rows. However this gives me back the number 15. which should be 85. Am i missing something here?

2

Hi @RobbinZD,

Welcome to our friendly community! :blush:

It seems I’m not quite clear on your goal. To better assist you, could you please:

  • Share a screenshot or video of what you’re working on (remember to hide any sensitive information), or
  • Submit a support ticket through our contact form.

Looking forward to helping you out!

3

Hi @Khai_To,

Ofcourse! im building a simple dashboard, where these kpi metrics show the amount of deals in that current stage

image
image2589×430 31.6 KB

They all use count(ID) to count the rows based on the specific conditions applied to get that stage.

I use the following business calculation as the condition for the field that seems to be going wrong:

image
image1361×929 93.5 KB

Which results in a count(Id) of 15. However that should be 85. As i can change the KPI metric to a sheet metric and see 85 entries in the database that match the conditions

image
image3453×1724 147 KB

Let me know if you need more context but thats the gist of it!

4

Hi @RobbinZD,

Thanks for sharing the image! It’s much clearer now what you’re aiming for.

In this situation, you don’t need to use the OR function in Business Calculation.

Firstly, it’s important to note that our OR function in Business Calculation isn’t meant to replace an OR Condition. Using it in our Visualization Condition might lead to unexpected results since it operates on your data’s result-set.

Secondly, as all expressions within the OR Condition come from the same Model Field, there’s no need for a Business Calculation. Instead, simply use our standard Visualization Condition. Apply the EQUAL operator and copy your ID list into our Filter Values. The image below provides more details.

image
image497×780 33.9 KB