Saturday, 7 November 2015

Applying colour formatting


1) Open Tableau Software & connect to the required Database. ( Coffee Chain (MS Access) has been taken as data source in this Example).
2) Drag Market Field from Dimension shelf to Column shelf Drag Date Field from Dimension shelf to Row shelf.  And drag Sales field from Measures shelf to intersection of rows & columns in work area.
3) Click on “+” symbol of Date field on Row shelf then we get the Quarters, & click on Quarters “+” symbol then we get the Months data.
4) Drag Market Field from Dimension shelf to Colour Marks shelf, it assign the colours automatically.
5) If we want to change the colours, double click on “South” on colours mark then assign the required colours.
6) The following example is illustrating colour formatting is applied based on Quarters.

No comments:

Post a Comment