Period over Period Analysis When 1 Data Point Stays Static

[LeeBee]

Hi,

I'm new to Looker Studio and I'm struggling with how to set up some of my data.

This is for a property management company to track their vacancies, leads and fulfillment.

The vacancy #s vary by property and week over week but they're generally the same units they're trying to fill while the leads that come in are new ones each week.

So if I setup comparison scorecards with controls I run into the following problem.

I can't do a sum aggregate for vacancies because then it totals the sum of available units each week, but if I drill down with a week filter on it then the #s are accurate.

I then tried to bring in a new data source with the total vacancies per agent per week which helped for having an accurate portrayal of average vacancies per week, but then I can't drill down to view the data on a property level.

How can I set this up to make sense?

Note that it's important for me to be able to have that vacancy # fluid and in the control because I'm then setting up comparison metrics of % leads generated per vacancy...

Any help would be greatly appreciated!

[sam8]

I'm having trouble wrapping my head around this one. Could you share some sample data that shows what kinds of numbers are appearing, versus what you'd like to see?

[LeeBee]

Hi,

Thank you for your help on this!
Can you see the link below for an idea of the data? (it's an underdeveloped
bogus sheet but just for reference)
https://docs.google.com/spreadsheets/d/1KjMsK8I8WFdq4ChREo_KNzrtDol1acOQ_syNZ5pF7rI/edit?gid=0#gid=0
[image: image.png]
My issue is that if there's no date filter applied to the data it'll add up
the vacancies for each week when really they are the same vacant units just
available over a period of time
I'd like to see how many actual physical vacant units there are
Let me know if you're following my question.

Thank You!

[sam8]

ah, that's helpful! Let me make sure I understand the issue correctly. I made a sample dashboard based on your data:

And the problem is that the default aggregation (SUM) would give 40 here, when in reality there are only 3 vacancies from the most recent record. Do I have that right?

[LeeBee]

Hey!

I'm not following where you're taking the # 3 or 40 from?

These are all different properties and I would want to know at any given
time how many vacancies there are across all properties (unless there's a
filter on for a date, specific agent or property)
So if there's no filter on I would want an average of the weekly
vacancies(for lack of better idea of how to most accurately portray the
#s), not a sum because that would mean the same single vacancy being
accounted for multiple times
If there's a filter for date I would want a sum of all vacancies available
at that particular time

This is important because say if I want to track how many leads I'm getting
per vacancy over a period of time I can't have the same vacant unit being
tallied 4x in a month
or how many vacancies convert to deposits in a month, I don't want that #
diluted by 4 because it's being tallied 4x over a month

but on the other hand when viewing the data with a weekly filter I want to
see the actual amount of vacancies that there were that week, not an
average because that totally screws the #s

Are you following?


--
*Kind Regards,*

*Leah Binet*
*Keen Teams LLC*
*Brooklyn, NY 11204*

<PII Removed by Staff>