Help counting in referencing a created dimension

fmorizur — Wed, 30 Jun 2021 14:41:46 GMT

I need help with the following.

1/ I have created a dimension, name is newKPI, with the following expression

=if([Mn-Ponctualité chargement]>$(vTolerancePlateforme)*-1 and [Mn-Ponctualité chargement]<$(vTolerancePlateforme),'Plateforme-A l heure',if([Mn-Ponctualité chargement]>$(vTolerancePlateforme),'Plateforme-En Retard',if([Mn-Ponctualité chargement]<$(vTolerancePlateforme)*-1,'Plateforme-En Avance','nc')))

I will get out of it 4 possibilities Plateforme-A l heure / Plateforme-En Retard / Plateforme-En Avance / nc

it's based on a variable vTolerancePlateforme

2/ I need then a count where I would like to replace the [KPI Tps-Plateforme (old)] (a previous field) by the newKPI (now variable based on the previous formula)

count(distinct {<[Q KPI-Ponctualité Plateforme]={'good quality'},[KPI Tps-Plateforme (old)]={'Plateforme-A l heure'}>} VoyageId)

how should I do this ? I have tried multiple attempts wo success.

THANKS

topic Help counting in referencing a created dimension in App Development

Help counting in referencing a created dimension