Vacancy Rate

Question

Vacancy Rate

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

.....use your code for vacant days and divide it by the code for total days......

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

jaggy99 Ten Centuries Points: 1308 More actions · Answer 2

Do we need to use Right outer Join as we are joining properties table with vacant table. Not all active properties are vacant.

Jag

jaggy99 Ten Centuries Points: 1308 More actions · Answer 3

in that case wouldn't it be easier to do the vacancy rate calculation in Tableau/Excel as it will be easier to apply the forumla?

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

jaggy99 (5/12/2016)
in that case wouldn't it be easier to do the vacancy rate calculation in Tableau/Excel as it will be easier to apply the forumla?

well if thats where the output ends up then fine...if thats what your users want.

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day