In this article, I will explain how to calculate percentage difference from the first column and when the first column is null then consider next available value in the same row. Formula % Difference = (Current Value – Previous Value)/Previous Value Step 1 Drag “Order Date” field to the filter shelf and choose current week. […]
How to write calculations to find the percentage difference in Tableau? Read More »
To calculate without referring dimensions present in the view, you can use Fixed level of detail calculations. Syntax:{ Fixed [Dimension field]: Agg_function([Measure Field]) } Example: {Fixed [Category]: SUM([Sales])} % of Total= SUM([Sales])/SUM({Fixed [Category]: SUM([Sales])})
Fixed LOD calculation to find Percent of Total in Tableau Read More »
Table: orderdetail item_id order_id product_id selling_price discount quantity 1 10001 1 9500 250 1 2 10002 1 9500 400 2 3 10002 2 1900 50 5 4 10003 5 6800 100 1 5 10003 4 990 0 2 6 10003 3 4950 10 1 7 10003 2 1950 25 2 8 10004 3 4960 0
SQL for BI – Orderdetail table Read More »
Table: orders order_id cust_id order_date ship_date payment_mode created_date 10001 1 2022-01-15 22:15:00 2022-01-16 09:15:00 Credit Card 15/01/22 10002 1 2022-01-24 04:15:43 2022-01-26 15:00:15 Net Banking 24/01/22 10003 4 2022-01-30 08:15:32 2022-01-30 13:15:00 Cash on Delivery 30/01/22 10004 5 2022-02-13 21:20:00 2022-02-17 14:09:10 Credit Card 13/02/22 10005 3 2022-02-14 18:00:14 2022-02-14 18:10:10 Credit Card 14/02/22 SQL
SQL for BI – Orders table Read More »
Task 1: Download “Sample Superstore 2022 – Excel data” file from here 1. Connect to the data source 2. Change the name of field “Product name” to “Product Description” 3. Change the data role for the “Order Date” field to Date && Time
