-
1. Re: Showing average increase in rental over years per neighbourhood on city map
Hello Tim,
Is this what you are looking for. I just wanted to make sure if I understood your question correctly.
-
2. Re: Showing average increase in rental over years per neighbourhood on city map
Hey Swaminathan,
I am looking to make something like below, but then with the map of Barcelona and the increase in rent. However, whatever I do I can seem to be able to turn the years into filters, which seems very crucial to do somehow. Would you know how to get to this?
And thank you so much for the quick respons! That really means a lot to me!
-
3. Re: Showing average increase in rental over years per neighbourhood on city map
Tim,
I'm having issue with your attached image. This is how it shows up for me. Would you be kind enough to attach a link for your referral dashboard. I'd be happy to assist you with it.
Regards,
Swami
-
4. Re: Showing average increase in rental over years per neighbourhood on city map
How do I add a link to a referral dashboard? I am really new to this all
-
5. Re: Showing average increase in rental over years per neighbourhood on city map
I found the dashboard you are using for reference. To achieve what you are looking for, I believe you need to restructure your data with a date/year column so that you can add it in the pages section of your workbook. Please find the image below to understand what I'm taking about.
To attach a packaged workbook Click on 'Advanced Editor and add attachment' then you'll have the option to attach a .twbx file.
Also, Please take a look at Calculate year-to-year population change on map with filter . Seems like this is what you are after. Let me know if you have any other questions.
Regards,
Swami
-
6. Re: Showing average increase in rental over years per neighbourhood on city map
Hey,
I think I attached it properly now?
Thanks for all the links!
-
7. Re: Showing average increase in rental over years per neighbourhood on city map
Yup. It is good. I was wondering if you could attach the .geojson file as well.
To pivot your data, Go to Data tab-> Hold control key and click on all the year columns -> right click and select pivot -> then change the year column type to date.
Regards,
Swami
-
8. Re: Showing average increase in rental over years per neighbourhood on city map
I have created the same using Parameters where you don't have to pivot the data. The labels need a little adjusting and moving around.
Hope this solves your issue. Let me know if you have any questions.
If this helped resolve your issue, I'd really appreciate it if you could mark this as answer and close the thread.It'll help others facing similar issue.
Regards,
Swami
-
9. Re: Showing average increase in rental over years per neighbourhood on city map
Hey Swaminathan,
I had a look, so cool that you got all the percentage changes to show on the map! However, they all show that rent is decreasing, while when you look at the data you see that the rent in all the neighbourhoods is increasing!
I did as you say and pivoted the data in order to create a years filter, I did this in Tableau prep and just to simplify it I did it with only the data of 2016/ 2017. (See attached file). However the issue then is that the different years disappear as a calculated field, so I can't make it into a slider anymore, as there is now just a calculated field with rent that includes all the different years compiled, which can then be filtered out by using the years filter created via pivoting. So now I need to find a way to just take the two years, calculate the increase in rent in percentage between 2016 and 2017 and then connect that to the GeoData (which is in the attached file as well, but I have included also a separate neighbourhood.geojson)
Wish this could be resolved via a skype call, such a complex program for beginners!
Thanks again for all the help so far, really making my day!
Cheers,
-
10. Re: Showing average increase in rental over years per neighbourhood on city map
Tim,
Thank you for the detailed explanation and thank you for the attachments. I'll look into in once I get back home from work. It's interesting.
Sure, if required we can set up a skype call and work together to get the result you need.
You have a wonderful day!
Regards,
Swami
-
11. Re: Showing average increase in rental over years per neighbourhood on city map
Hey Swami,
Hope you have a great weekend ahead!
Did you have a change to look at it a little bit more?
Cheers,
Tim
