-
1. Re: How to show new stores added this week versus last week?
Matthew Risley Dec 1, 2016 10:31 AM (in response to Mark Fagan)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
-
2. Re: How to show new stores added this week versus last week?
Mark Fagan Dec 1, 2016 10:45 AM (in response to Matthew Risley)I will try to post something soon but was hoping to avoid doing that...
-
3. Re: How to show new stores added this week versus last week?
Matthew Risley Dec 1, 2016 11:01 AM (in response to Mark Fagan)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!
-
4. Re: How to show new stores added this week versus last week?
Mark Fagan Dec 1, 2016 11:37 AM (in response to Matthew Risley)Thanks for talking a look Matthew! Much appreciated!
-
global superstore training.twbx 285.1 KB
-
-
5. Re: How to show new stores added this week versus last week?
Eric Van Blargan Dec 1, 2016 12:21 PM (in response to Mark Fagan)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
-
6. Re: How to show new stores added this week versus last week?
Ashish Chaudhari Dec 2, 2016 12:35 AM (in response to Mark Fagan)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
-
global superstore training.twbx 16.5 KB
-
-
7. Re: How to show new stores added this week versus last week?
Mark Fagan Dec 21, 2016 1:34 PM (in response to Ashish Chaudhari)Thank you Ashish! I will check it out!