4 Replies Latest reply on Feb 7, 2018 5:44 PM by LAWRENCE Slash

    Calculation with Data Range and more than 1 filter

    LAWRENCE Slash

      Please I need help with this logic.

      I keep getting an error message.

      Help please.

       

      If ATTR([Measure Date])>= #2017 -01-01#

      and ATTR([Measure Date])< #2018 -01-01# 

      and [Reporting Period]=' Active Year'

      and [Measure] = 'Run'

      THEN SUM([Measure Count])

      END

        • 1. Re: Calculation with Data Range and more than 1 filter
          Shinichiro Murakami

          HI Lawrence

           

          You need to align aggregation level just as error massage says.

          Tyr this .

           

           

          If ATTR([Measure Date])>= #2017 -01-01#

          and ATTR([Measure Date])< #2018 -01-01#

          and attr([Reporting Period])=' Active Year'

          and attr([Measure]) = 'Run'

          THEN SUM([Measure Count])

          END

           

          Thanks,

          Shin

          • 2. Re: Calculation with Data Range and more than 1 filter
            LAWRENCE Slash

            Thanks a lot.

            It worked.

            Have a great day.

             

            Sent from Yahoo Mail on Android

             

              On Wed, 7 Feb 2018 at 12:16, Shinichiro Murakami<tableaucommunity@tableau.com> wrote:   

            #yiv2604329129 * #yiv2604329129 a #yiv2604329129 body {font-family:Helvetica, Arial, sans-serif;}#yiv2604329129 #yiv2604329129 h1, #yiv2604329129 h2, #yiv2604329129 h3, #yiv2604329129 h4, #yiv2604329129 h5, #yiv2604329129 h6, #yiv2604329129 p, #yiv2604329129 hr {}#yiv2604329129 .yiv2604329129button td {}

            |

             

              Tableau Community 

             

             

             

            |

            Calculation with Data Range and more than 1 filter

             

            reply from Shinichiro Murakami in Forums - View the full discussion

             

            HI Lawrence

             

             

             

            You need to align aggregation level just as error massage says.

             

            Tyr this .

             

             

             

             

             

            If ATTR()>= #2017 -01-01#

             

            and ATTR()< #2018 -01-01#

             

            and attr()=' Active Year'

             

            and attr() = 'Run'

             

            THEN SUM()

             

            END

             

             

             

            Thanks,

             

            Shin

             

            Reply to this message by replying to this email, or go to the message on Tableau Community

            Start a new discussion in Forums by email or at Tableau Community

            Following Calculation with Data Range and more than 1 filter in these streams: Inbox

             

             

             

             

            This email was sent by Tableau Community because you are a registered user.

            You may unsubscribe instantly from Tableau Community, or adjust email frequency in your email preferences

             

             

            • 3. Re: Calculation with Data Range and more than 1 filter
              Shinichiro Murakami

              Hi Lawrence

               

              You are welcome and could you mark my answer as correct to close the thread.

              Not fro inbox, but from original post.

               

               

               

              Regards,

              Shin

              • 4. Re: Calculation with Data Range and more than 1 filter
                LAWRENCE Slash

                Ok I will do that  ASAP.

                 

                Sent from Yahoo Mail on Android

                 

                  On Wed, 7 Feb 2018 at 16:14, Shinichiro Murakami<tableaucommunity@tableau.com> wrote:  

                #yiv0890142143 * #yiv0890142143 a #yiv0890142143 body {font-family:Helvetica, Arial, sans-serif;}#yiv0890142143 #yiv0890142143 h1, #yiv0890142143 h2, #yiv0890142143 h3, #yiv0890142143 h4, #yiv0890142143 h5, #yiv0890142143 h6, #yiv0890142143 p, #yiv0890142143 hr {}#yiv0890142143 .yiv0890142143button td {}

                |

                 

                  Tableau Community 

                 

                 

                 

                |

                Calculation with Data Range and more than 1 filter

                 

                reply from Shinichiro Murakami in Forums - View the full discussion

                 

                Hi Lawrence

                 

                 

                 

                You are welcome and could you mark my answer as correct to close the thread.

                 

                Not fro inbox, but from original post.

                 

                 

                 

                https://community.tableau.com/servlet/JiveServlet/downloadImage/2-722183-409312/580-245/pastedImage_0.png

                 

                 

                 

                 

                 

                Regards,

                 

                Shin

                 

                Reply to this message by replying to this email, or go to the message on Tableau Community

                Start a new discussion in Forums by email or at Tableau Community

                Following Calculation with Data Range and more than 1 filter in these streams: Inbox

                 

                 

                 

                 

                This email was sent by Tableau Community because you are a registered user.

                You may unsubscribe instantly from Tableau Community, or adjust email frequency in your email preferences