Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

I have been working on data visulization which shows us the office markets and i want to focus on object type instead regional, national or global market levels

Let us consider they are,There is a property A which has tenanta A,B,C and A and B has been in the building from the time it was constructed.B has join in middle like after 6 months

PropertyName} {CompanyName} {StartDateLease} {EndDateLease} {LeaseSize} {PropertySize} {PropertyVacancy} 

  Building A Tenant A 01-01-2011 01-01-2016 2000 5000 [CalculatedValue] 

1 Answer

0 votes
by (22.5k points)

Calculated feild:SUM(IF CONTAINS([Occupied by],'Tenant') THEN [LeaseSpace] END) / SUM([LeaseSpace])

If you want to learn more about it Tableau, then go through this Tableau Training for more insights.  

Related questions

0 votes
2 answers
asked Dec 10, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer

Browse Categories