Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
DarkTemplar
Contributor
Contributor

Help set analysis embedded expression

Hello,
I am trying to make a dashboard for my application but I am stuck on filling in my KPI. I'm looking to get the number of people with >= 6 days of absence of type "" but the formula always returns 0.

count({$<Nom = {"Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

Nom

Type de congés

Conges_Date

Daniel

non régularisé

14/11/2022

Daniel

non régularisé

15/11/2022

Daniel

non régularisé

16/11/2022

Julie

Décès

12/04/2022

Julie

Décès

14/04/2022

Bruno

non régularisé

19/04/2022

Bruno

non régularisé

20/04/2022

Bruno

non régularisé

21/04/2022

Bruno

non régularisé

22/04/2022

Bruno

non régularisé

23/04/2022

Bruno

non régularisé

24/04/2022

Bruno

non régularisé

25/04/2022

Emma

Décès

02/05/2022

Emma

Décès

03/05/2022

Emma

Décès

04/05/2022

Pierre

non régularisé

17/06/2022

Pierre

non régularisé

18/06/2022

Pierre

non régularisé

19/06/2022

Pierre

non régularisé

20/06/2022

Pierre

non régularisé

21/06/2022

Laura

Mariage/PACS

05/08/2022

Laura

Mariage/PACS

07/08/2022

Laura

Mariage/PACS

08/08/2022

Laura

Mariage/PACS

09/08/2022

Laura

non régularisé

31/10/2022

Laura

non régularisé

01/11/2022

Laura

non régularisé

02/11/2022

 

Thank you for your answer.

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

View solution in original post

2 Replies
tresesco
MVP
MVP

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)

DarkTemplar
Contributor
Contributor
Author


@tresesco wrote:

Just a quick glance says, you are missing one '='. Try like:

count({$<Nom = {"=Count({1< [Type de congés] = {'non régularisé'}>} Conges_Date) >= 5"}> } distinct Nom)


Perfectly functional, thank for the correction