4 Replies Latest reply: Jun 3, 2014 5:47 PM by francesca pisu RSS

    Indirect Set Analysis

    francesca pisu

      Hi all,

      i have a problem with set analysis.

      I have this expression that give me as result 26130 records:

       

      =Count({$<Nome_Profilo=P({<Sending_mean__c={Online},Profile_state__c={Attivo}, Commodity={'Gas','Power'},CreatedDate={'>=$(=varDate)'}>}Nome_Profilo)>}Nome_Profilo)

       

      I want to know about this 26130 records, which have Created_Date > Date

      where Date is another date fields.

       

      How can i do?

       

       

      Thanks a lot

        • Re: Indirect Set Analysis
          Liron Baram

          if the field you wnat to compare the created date

          has diffrent value for diffrent records , then you need to use if statement

          as set analysis wil check for the same date to all values

          so your formula sholud look somthing like

           

          Count({$<Nome_Profilo=P({<Sending_mean__c={Online},Profile_state__c={Attivo}, Commodity={'Gas','Power'},CreatedDate={'>=$(=varDate)'}>}Nome_Profilo)>}aggr(if(Created_Date > Date,Nome_Profilo),Nome_Profilo))

            • Re: Indirect Set Analysis
              francesca pisu

              thank you Liron.

              I have another question to you.

               

              I calculate progressive expression by using option in expression tab :

               

              count({$<Sending_mean__c={Online},Profile_state__c={Attivo},Billing_email__c={''}>}Nome_Profilo)

              I calculate this expression Group by MonthDate..

               

              I need to know difference between Progressive May 2014 and September 2013.

               

              How can i do?

               

              Thanks a lot

               

              Francesca

               

               

                • Re: Indirect Set Analysis
                  Liron Baram

                  hi maria

                  can you elaborate , little bit more

                  what is the dimension of the chart where you want to compare the month

                  and do you always compare months to a month 8 months back

                  or the user should select the months he want to compare

                    • Re: Indirect Set Analysis
                      francesca pisu

                      Thanks Liron.

                      I have another question for you. I need to calculate difference between two dates but with two different condition. I use the Only function but it works only for one condition. How can i do?

                       

                      The one condition is:

                       

                      =only({<Categoria__c={'Attivazione'},Subject={'Verifica e correzione dei dati'},State__c={'Nuovo'},Status_Task={'Completata'},Stato_Pipeline={'1 Check Doc','2 Credit Check','3 Check Call','3 Check Letter','4 Gest. UTF','5 Invio Recessi','6 DL','6 DL KO','7 Non fatturabile','8 Fatturabile','0 Annullamenti'}>}round( LastModifiedDate_Task-CreatedDate_Task))

                       

                      The second condition is:

                       

                       

                      =only({<Categoria__c={'Attivazione'},Subject={'Verifica e correzione dei dati'},State__c={'Attivo'},Status_Task={'Completata'},Stato_Pipeline={'7 Non fatturabile'}>}round( LastModifiedDate_Task-CreatedDate_Task))

                       

                       

                      How can i do to have the difference of two date in one expression?

                       

                      Thank you