![]() I flipped the columns and rows, so my starting point was as below. This created a tabular view of the data so I could work on getting the calculations I need for the filtering. To help with this, the first thing I did was to Duplicate as crosstab (right click on the chart tab). My next step at this point was to work on the filtering requirement. I adjusted the tooltip, made the chart dual axis and synchronised the axis, then removed Measure Names from the Colour shelf that had automatically been added. I then used the context menu on this pill to set a Quick Table Calculation of type Moving Average.īy default this sets the average to the 3-month rolling average as per the requirement. ![]() I then added another instance of Sales to the Rows shelf next to the existing one, changing the mark type of this instance to Line and setting the Colour to a darker blue at 100% opacity. I changed the mark type to Area, set the Colour to a blue, dropping the opacity to 50% in an attempt to match Sean’s colouring and adjusted the tooltip. I then added this to the Columns shelf as a continuous (green) exact date, and added Sales to the Rows shelf. ![]() The grain of the chart was at the month level, so I first created a specific field to store the Order Date at this particular level Now I was ready to start building out the requirements. Unsure as to whether there was any auto save facility online, I decided to save the workbook pretty much immediately, although I was first prompted to navigate to the Data Source tab and create an Extract before I could save. When prompted I then chose to upload from computer, the data source file I’d downloaded, and once done I was presented with the online canvas to start building I saved this locally then logged into Tableau Public online and started the process to build a viz online, by clicking the Create a Viz (Beta) option. Most challenges use a version of Superstore Sales which I usually already have on my laptop, due to the multiple instances of Tableau Desktop installed, but this time, I had to get the data from data.world. It was Sean Miller’s turn this week to set the challenge, which had an added twist – to complete only using the web authoring feature in Tableau Public, something I’d never tried before.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |