2 Replies Latest reply on Dec 13, 2017 9:32 AM by Nicolas Planchon

How to get an average with criteria ?

Nicolas Planchon Dec 13, 2017 7:13 AM

Hi there,

I have a little issue: I want to calculate an average of an amount of sales in a gap of (D-15;D+15). I have used a binary var to target my D. The D day is 1 in my var [DAY_OR_NOT] and other days are 0.

Do you know how I can process to generate my average on this (D-15;D+15) gap please ?

Thanks in advance,

Nicolas.

1. Re: How to get an average with criteria ?

Matthew Theis Dec 13, 2017 7:57 AM (in response to Nicolas Planchon)

Hello Nicolas Planchon I would suggest putting [Day_or_Not] as a filter. Select 1. Then pull the same pill onto the marks card as AVG. Let me know if this works
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to get an average with criteria ?

Nicolas Planchon Dec 13, 2017 9:32 AM (in response to Matthew Theis)

Hi Matthew Theis, thanks for your feedback!

Unfortunately this will only allow me to get an average on the D Day, but I also want to include sales of the 15 days before this D Day and 15 days after this D day.
I think it's a little bit trickier!

Nicolas.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

How to get an average with criteria ?

1. Re: How to get an average with criteria ?

2. Re: How to get an average with criteria ?

Actions

More Like This