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!!!
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
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
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.
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 ?
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...
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.