Mark,

Would it be possible to post a .twbx file so that we could help you out? It will make it easier for others to work out a solution.

PS: I use 9.3, but would love to help on this issue.

Best,

--Matt

It can be as simple as just the data in the picture. It's just easier than trying to re-create the problem, "solve it", then walk you through reverse engineering the solution

Anything helps!

Mark,

I would suggest using an LOD calculation to find the minimum date for each store, and then doing a calculation to see if that minimum date is within a week of today.

Calculation 1:

{Fixed [store] : min([We Date]) }

Calculation 2

IF DATEDIFF('week',[Calculation 1],TODAY()) <1 THEN [Store] END

This should only present you with those store names.   For the workbook you provided, if you change Calculation 2 to < 2, you'll see that C is the only store name that appears.

Hope this helps.

Eric

Hi Mark,

Answer to your question is quite simple I guess. Please refer to the below screenshot. I tried calculating with your provided data.

Textual Calculated field:

 

{ FIXED [Store] : if MIN([We Date])=MAX([We Date]) THEN "New Store"

ELSE "Old"

END }

I hope this helps. Attaching the Tableau workbook which might not open since you are using bit older version than what I am using currently.

Thanks and Regards,

Ashish Chaudhari