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

# Calculation with Data Range and more than 1 filter

Please I need help with this logic.

I keep getting an error message.

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

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

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

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

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.

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