4 Replies Latest reply: May 27, 2016 1:59 AM by reddy r RSS

    Expressions

    reddy r

      Table1:

       

         

      IDFixedStatusTest_Datevalues
      100Napproved8/8/2016Text
      200Napproved26/05/2016Text1
      300Napproved27/05/2016Text1
      400Napproved10/10/2016Text1
      500NReject10/12/2016Text4
      500YReject10/12/2016Text4

       

         

       

      three bar charts can be displayed on below 3 conditions

      1)Where Status = approved

      Fixed = 'N'

      today date is greater than the Test_Date-60   (bar chart)

      2)Where status = approved

      Fixed = 'N'

      today date is is greater than the Test_Date  (bar chart)

       

      3)Where Satus = Reject

      Match where the role has Text4 (bar chart)
      Could you please help on above three set expressions.

        • Re: Expressions
          Sinan Ozdemir

          Hi reddy,

           

          What is the dimension you want to use and what function do you want to use in the expressions SUM, COUNT, etc?

           

          Thanks

            • Re: Expressions
              reddy r

                 

              IDFixedStatusTest_DatevaluesDate
              100Napproved8/8/2016Text8/8/2016
              200Napproved26/05/2016Text126/05/2016
              300Napproved27/05/2016Text127/05/2016
              400Napproved10/10/2016Text110/10/2016
              500NReject10/12/2016Text410/12/2016
              500YReject10/12/2016Text410/13/2016

               

              Dimension is Date field

               

              and we can use count

            • Re: Expressions
              Santiago Respane

              Hi reddy,

              i dont know which kind of aggregation you want to use in your expression nor which field but your expression will look something like this:

               

              Lets say you will use a sum operation for the field amount...(you can change them).

               

              1. =SUM( {<Status={"aprooved"},Fixed={"N"},Test_Date={"<$(=Date(Today()-60, 'D/M/YYYY'))"}>} Amount)


              2. =SUM( {<Status={"aprooved"},Fixed={"N"},Test_Date={"<$(=Date(Today(), 'D/M/YYYY'))"}>} Amount)


              3. =SUM( {<Status={"Reject"},Values={"Text4"}>} Amount)

               

              It not that easy to create the expression with the little information you provided.

              Please let me know if this helps.

               

              Kind regards,

                • Re: Expressions
                  reddy r

                     

                  IDFixedStatusTest_DatevaluesDate
                  100Napproved8/8/2016Text8/8/2016
                  200Napproved26/05/2016Text126/05/2016
                  300Napproved27/05/2016Text127/05/2016
                  400Napproved10/10/2016Text110/10/2016
                  500NReject10/12/2016Text410/12/2016
                  500YReject10/12/2016Text410/13/2016

                   

                  Dimension is date

                  today date should be greater than the Test_Date-60 

                  Distinct ID can be used instead of amount