This particular one was a bit interesting as the data was in very detailed format. There was a lot of interesting and wonderful dashboards already created by the makeover monday crew and I was wondering how to visualise the data a bit more differently. Before we get there here is an overview of the original visualisation.
Its an average overall dataviz.
What I wanted to do was to compare the average and total price of avocado quarterly. In order to do so I decided to blend and edit the data in Alteryx. The idea was to get the Weeks for each date, then to which quarter of the year it belongs to and lastly count the weeks for each quarter and reset the week to 1 for each quarter.
In the final dataviz I have got a line chart comparing current quarter with the previous quater and the previous year’s same quarter as current quarter.
Look at total price of Avocado region wise. Look at QTD total price, volume, days left. Glimps of last 5 days total Avocado price. Also a quaterly metric of total price for conventional and organic Avocado.
DataVisalytics 