Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 28, 2017, 12:13 AM

Same Store calculation

I have a long data set that is at a building ID level and I want to show same store YoY units.

Here is a sample table below:

Bldg_IDUnit_typeRent/MoUnit_countStatement_Yr1A1 Bdrm$1002220162A2 Bdrm$1501020172B3 Bdrm$250520161A1 Bdrm$1052320172B3 Bdrm$23562017

Effectively, I want to get only records with 2016 and 2017 data. That means that Bldg_ID 2B is being added to my data even though I have no data in 2016 to compare.

Is there some kind of LOD calculation to compare Same Store? I'm trying to get a sum of each Unit_Count from 2017 where there were also the same Bldg_ID and data in 2016. Does that make sense?

Thanks.

2 answers
  1. Simon Runc (Atheon Analytics)
    Oct 28, 2017, 9:45 AM

    hi Greg,

     

    I think this is what you want

     

    Retail Sales LFL Measure (…made Simple with LoD Calculations)

     

    Although without week you'd want

     

    {FIXED [BuildingID]: COUNTD([Years])} = 2

     

    pop this on the filter shelf and set to true

Write an answer...
0/9000