How to show running average of profit?

0 votes
I want to see sales and profit over a month for a region. How to show profit/loss as well in same chart?
Apr 3 in Tableau by Sindhu
7 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi,

Follow below steps:

1. Create a bar chart sales and profit over month over a region.

2. Now convert the sales, profit to avg measure.

3. Convert into running total from quick table calculation.

4. Now convert the bar to gantt under marks pane.

5. Create 2 calculated field with values of -avg(sales) and -avg(profit) to provide the size of bar.

6. Now add both field to respective panes.

7. Now add sales and profit to color section.

A running average for profit and sales are shown as above, where color shows increase/decrease details.

The above similar chart for day based on a month would look like this to show profit or loss better way.

Hope this helps you.

answered Apr 3 by CHERUKURI
• 13,860 points

Related Questions In Tableau

0 votes
1 answer

How to show % of the total to each bar in bar graph?

Hi Manu, It is a simple procedure, Follow ...READ MORE

answered Apr 22 in Tableau by CHERUKURI
• 13,860 points
31 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,200 points
74 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,905 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by Atul
• 5,470 points
45 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
916 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
36 views
+2 votes
1 answer
0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2 in Tableau by CHERUKURI
• 13,860 points
9 views
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17 in Tableau by CHERUKURI
• 13,860 points
32 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.