2 Replies Latest reply on Sep 6, 2017 5:54 AM by jo.bi

# Take Min Value per Week Number

Hello all,

See Excel worksheet attached.

In letter S, for every single day, we color in red (NO) or green (YES) depending whether or not an event happened.

Then, we show results for each week (top right of Excel): if there is at least a red event during a week, then week becomes red. if there are only green events during a week, we show week as green.

Now I want to do this in Tableau:

I managed to represent letter S and event, so circles in S letter become either red (NO) or green (YES) for each day.

I also created another worksheet, that shows cases as week numbers (like in Excel top right).

But now, I'm wondering which calculation to use for computing events (green or red) for each week number:

IF [Events] = all "yes" THEN weeknumber = Green

ELSEIF [Events] = at least 1 "no" THEN weeknumber = Red

Might be using WINDOW_MIN, WINDOW_COUNT or LOD { FIXED: } ??

• ###### 1. Re: Take Min Value per Week Number

Hi Jo,

Something like:..... If {fixed weeknumber: min: yes/no}="no" then "Red" else "Green" end should do it.

Regards,

Norbert

2 of 2 people found this helpful
• ###### 2. Re: Take Min Value per Week Number

Thank you Norbert!