LOD Example using SuperStore

Observe:

When the parameter is set to State all the LOD values across the sate remains same (even if the report is drilled to city) across Category and Segment
When Category is selected, the LOD values are constant for each of the columnar Category for all States and Segments
When Segment is selected, the Colored Segments same across all states and Categories

Two Calculated Fields and a Parameter

1. LOD Avg Sales

2. LOD Values

Parameter LOD

The drop-down Parameter LOD controls the calculated fields LOD Values and the LOD Avg Sales based on the choice made by the user

Comments

Retail: Shipping Time Analysis using Tableau

This report is based on the calculated field called Shipping Time, where 'Time to Ship' formula is as below: The two charts 'Ship Time by Year' and 'Ship Time by Month' are a Filled Area map of the - Number of Orders (Y Axis) - Days to Ship (X Axis) Colored By - Year - Months The 'Timely Shipment' chart is colored by whether 'Ship Mode' is 'Early', 'On-Time' or 'Late' Based on a business Logic per formula below: The report below is interactive using Dashboard Action filters. Uses OOTB retail data that comes with Tableau installer.

Tableau Fiscal Calendar Dynamic Choice

Created an example, where User can choose the starting Month and the report dynamically updates to show corresponding Fiscal Months, QTR and YR

Ojoswi On Tableau

Search This Blog