Tableau - compare current year vs previous year trend
This tutorial will reflect comparison of current year vs previous year. Just follow the steps shown in this video and enjoy.
#practicalit #previousvscurrentyearcomparision #yoychange
This tutorial will reflect comparison of current year vs previous year. Just follow the steps shown in this video and enjoy.
#practicalit #previousvscurrentyearcomparision #yoychange
Пікірлер: 25
Brilliant. Worked first time. Great explanation. Easy to follow and recreate using my client's data. You saved me too! Thank you, thank you, thank you!!!
Very Clear and absolutely informative. Thanks for sharing..
Thanks for uploading such a informative video...
parameterizing the years and making customer centric was very useful.
Thank you very much, you have helped me a lot! You are the best, really, thank you very much!
Very helpful for a newbie in Tableau.. Didn't expect it would be that simple haha Very much thanks!
@practicalit91
3 жыл бұрын
Glad to know it helped..
Very helpful thanks.
hi ! Its really amazing, your logic compared the current and previous very easily in one go , Can you please explain how color Palette is doing it so easily , as we have not written any calculation but still we were able to do it with just color segregation? , I am still wondering how adding the calculation to color made it work ?
This is helpful and great tip. Love your videos. I have a question, when i do current YTD vs prior heard YTD calculations i get the right data. My dashboard is set to show this year (current) data, when the end user selects last years data, the Prior year is blank. How do i fix that it picks up last year data anytime a previous year or the last two years are selected to display those KPIs? Please and thank you for everything Fidan
It's so good easy and understanding ❤️ thanks for sharing 👍
@practicalit91
3 жыл бұрын
Glad to know it helps
Thank you, it's very helpful. Is there a way to show sum(profit) label at month level insteat of year level?
calculating the sum of profit for the years in super data store DATASET, but while comparing the amount shown un your visual does not match. ex : comparing 2019 and 2020 , profit shown in the visual is 1788 for 2020 and 8017 for 2019, whereas i see the profit is 81795 for 2020 and 61619 for 2019. kindly correct me if i am wrong.
Thank you for this video. I have one question. I have custom date ranges to compare current year vs previous year. For example if I have to compare data from April of one year thru March of other year (12 months) instead of Jan thru Dec. how can we do this
when am doing day(ex: 21/3/2024), chart is not comparing, its coming up as continuous
Hi I need some help with my data
if I want to show the % difference between previous month and current month ...in only the data table how can I do that ? Can you please please help
@wtfsattawtf
3 жыл бұрын
You would use the Lookup function in a Table Calc calculated field. Essentially looking up the the value on the previous row/column and using your percentage change formula.
Thanks really helpful. What if my year runs from April to March ? Tableau defaults to Jan - dec for a year so I have set the order date as fiscal year starts as April but I end up losing Jan-March into the new year. Can you help please ?
@practicalit91
3 жыл бұрын
Let's say for fiscal year FY21 months would start from April 2020 to March 2021..are you talking about months from Jan 21 to March 21 ?? If yes, i have tested this scenario using calculation field and it includes these months...
@911alps
3 жыл бұрын
@@practicalit91 I can’t seem to get that to work - is there anyway we can communicate to discuss please
@BinduVattikoti
Жыл бұрын
@@practicalit91 please make more videos on functions
Bro u just saved me from client. But can you help how to calculate yoy in this.
@practicalit91
2 жыл бұрын
kzread.info/dash/bejne/k42s2LOcqtm-mpM.html check this video