1 Reply Latest reply on Mar 13, 2016 11:08 PM by Takaaki Koseki

Calculation for showing data of this current week

Hello,

I am still learning on Tableau and am currently needing help with a calculation. I am creating a report that will show me real time data for the current week.

Attached is an excel spreadsheet of the data I am trying to filter through.

My formula is showing me the Scheduled Starts and should count all rows with A Status and rows with START Status that have a Start Date of today. However, I am wanting to change the TODAY() to somehow count rows with START Status that have a Start date of this current week, which is Sunday through Saturday (3/6/16-3/11/16).

The ideal calculation would be something like this:

IF ([Status] = 'START' AND [Start Date] = THIS WEEK()) THEN 1

ELSEIF ([Status] = 'A') THEN 1

ELSE 0

END

And the total count would give me 19 records instead of 17.

I attached a workbook that has the calculated formula of Scheduled Starts (This Week) in case that helps.

• 1. Re: Calculation for showing data of this current week

Hi.

Try DATETRUNC by week.

```IF ([Status] = 'START' AND DATETRUNC('week',[Start Date]) = DATETRUNC('week',TODAY())) THEN 1
ELSEIF ([Status] = 'A') THEN 1
ELSE 0
END
```

Thanks.