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