Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
@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