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

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

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 Comparison with Calculated Field

At the very onset, this Tableau report is based on a Calculated field. After Left joining Orders table to Returns table on Order ID, only those orders that were returned were marked accordingly and the rest were left as 'Sales Retained'  Above calculated field is used on the color pill to render Viz in the example below.  The published report starts with a  1. Summary viz with the Returned Sales $ are calculated as a percentage of the Sales $ on that day and plotted over time series. Once can infer that Q1 of both 2012 and 2013, majority of the retail transactions have been Returns 2. Area chart on the top left plots running total of the Returned Sales $ as a percentage of total Sales (for the entire data set). This viz is particularly useful is concluding that there is a considerable surge in returns on the last week of March 2014. Also some comfort from the fact that Returned Sales $ is merely 8% of Total Sales 3. The Correlations bubble chart plots the S...
Post a Comment
Read more