topic Re: 2 two set analysiss expression in one expression in App Development

2 two set analysiss expression in one expression

jmialoundama — Fri, 20 May 2022 09:06:46 GMT

Hi,

Hello,
I have these two expressions.

The first expression allows me to calculate the "Notified closed" status of the previous 3 years:

=count({$<echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié cloturée"}>}DISTINCT key_nb_poste_commande)

The second expression allows me to calculate the status "Notified not closed for the next 3 years" :

=count({$<echeance_date_YYYY={">=$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié non cloturée"}>}DISTINCT key_nb_poste_commande)

I want to combine these 2 expressions in a single expression in order to have this result in my table:

Thanks 🙂

vinieme12 — Fri, 20 May 2022 09:14:27 GMT

1) Use a Pivot Table

2) Add Both Measures

3) Add dimension "echeance_date_YYYY" to the column section

4) Drag "Values" from Measure Section to Column Section (above Year)

vikasmahajan — Wed, 08 Jun 2022 04:25:08 GMT

you can use or condition in set analysis

=count({$<echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié cloturée"}>}

+ <echeance_date_YYYY={"<$(=year(today()))"},[Notifié cloturée/Non cloturée]={"Notifié non cloturée"}>}
DISTINCT key_nb_poste_commande)

refer links:

thanks

Vikas

jmialoundama — Mon, 20 Jun 2022 22:28:28 GMT

Thanks you all for your help