Skip to main content

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

Post a Comment

Popular posts from this blog

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.
Post a Comment
Read more

Tableau Dynamically Adjusting to Screen Resolution

This Tableau dashboard would automatically adjust its presentation based on the screen size used to view this report Example embedded below:
Post a Comment
Read more

Tableau: Year Over Year Metrics Comparison

Created a Tableau Viz using the OOTB Data Set to do a Yea over Year metric comparison, where the two years to be compared are user interactive choice. Incorporates the following features: 1. Trend Charts YoY using color marks at a Monthly granularity 2. Box and Whisker Viz with YoY using color marks at a Monthly granularity 3. Trend and 4. Histogram YoY using color
Post a Comment
Read more