8 Replies Latest reply on Dec 14, 2016 12:31 AM by Keerthi Jagannath

# Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

This might have been a redundant question, but I could not find any answers with my serach keys. COuld you kindly help me?

The comparison is with the increase and decrease in volumes of a certain product to be shown also in percentage difference.

• ###### 1. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Hi Keerthi,

Before I gave any suggestion please make my understanding correct. You have two years of data and you want to compare both years data in Bar chart for Quarter/month/year. Please refer to below screenshot and let me know whether I understood correct or not.

1 of 1 people found this helpful
• ###### 2. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Hi Sandip.

Yes this is what I am looking for. Thank you.

Could you kindly explain on a high level about the steps and calculated fields?

Thank you.

• ###### 3. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Also,

What would be the solution if I have to comapare 2 consecutive parameters (Eg: Jan and Feb or Q1 and Q2) within the same year?

• ###### 4. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Hi Keerthi,

• ###### 5. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Hi Sandip,

Thank you. But unfortunately, i guess it is a workbook from a recent version of Tableau. I have V9 installed. So I am unable to access.

• ###### 6. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Hi Keerthi,

You can understand the concepts of Dual Axis chart from here.

You need to create dual axis chart with current year data on one axis and previous year data on other.

1 of 1 people found this helpful
• ###### 7. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Tell me your full version name, so that I can convert that workbook.

• ###### 8. Re: Hello All. I am trying to figure out, how to make a Bar in bar chart for comparing 2 consecutive quarters/years/months and comparing 2 quarters/years/months between 2 different years.

Sandip.. Sorry for the delay.. My current version is Tableau 9.3.

I have an additional doubt. I was able to create the needed visual.

I have used the filter top 10 out of 1000s of records. But I need the top 10 in 2 ways. Top increase and Top decrease.

I know, i need to put a conditional top 10 or bottom 10, but I am confused with the formula.

I am supposed to show the increase and decrease in the difference from previos month to this month.