Actual Profit Versus target profit comparision by using LOD function

Actual Profit Versus target profit comparision by using LOD function
Actual Profit Versus target profit comparision by using LOD function
Explanation:

Actual vs. target?

  • Create a calculated field Difference between Actual and Target Profit.
  • Calculation looks like below:

[Profit]- [Target Profit]

  • Create LOD function fixed on the Product, calculation name is: Difference Between Actual and Target by Product

Calculation is: {INCLUDE [Product]: SUM ([Difference between Actual and Target Profit])}

  • Create one more calculation for Number of Products above Target.
  • Calculation field is: IIF([Difference Between Actual and Target by Product] > 0, 1, 0)
  • Create a calculation for above calculation and name it as Percentage of Products Above Target. Calculation is: SUM([Number of Products Above Target]) / COUNTD([Product])
  • Drag Difference Between Actual and Target by Product into Columns. And select the aggregation as SUM.
  • Drag Percentage of Products above Target into Columns.
  • Drag State into Rows and right click on that and select sort option then it will open the sort window in that select the fields as shown below.

Actual Profit Versus target profit comparision by using LOD function

  • Drag Difference between Actual and Target Profit into Color at Difference Between Actual and Target by Product Marks Card.
  • The visualization will look like below

Actual Profit Versus target profit comparision by using LOD function

Product breakdown?

Ans:

  1. Drag product into columns then right click and select Sort option. In that select the fields as shown below.

Actual Profit Versus target profit comparision by using LOD function

  1. Drag Profit into Rows.
  2. Now drag Difference between Actual and Target Profit into Color shelf at Marks card level.
  3. And drag the Target Profit into Details at marks card level.
  4. Right Click on the Profit Header at visualization level and select Add Reference Line as shown below.

Actual Profit Versus target profit comparision by using LOD function

5. The visualization looks like below.

Actual Profit Versus target profit comparision by using LOD function

  1. how to find the server Disk Space?

EXPLANATION

Use the Server Disk Space view to see how much disk space is in use on the computer or computers that run Tableau Server, where disk space refers only to the partition where Tableau Server is installed. You can also use this view to identify sudden changes in disk space usage.

For a distributed installation, the view displays information about each computer in the cluster.

Actual Profit Versus target profit comparision by using LOD function

The Server Disk Space view includes two graphs:

What is the most recent disk space usage?—This graph shows disk space usage for the last 30 days both in gigabytes and as a percentage. Disk space refers only to the partition where Tableau Server is installed.

How has free disk space trended in the last month?—This graph shows changes to disk space usage over the last month. Rest your pointer on a line to view the exact amount of free disk space for a point in time.

When Tableau Server is low on disk space, you can remove files to free space.

Tip: You can have Tableau Server alert you when free disk space falls below a threshold that you specify.

 

Leave a Reply

Your email address will not be published. Required fields are marked *