3 Replies Latest reply on Nov 28, 2016 11:12 PM by K V

# calculations for Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg in single Axis

The sample data attached here.

I would like to develop dashboard for the below calculations for  Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg.

Calclations:

Total count Against column D:

Total Handled time against column D

I also few of the other measures around (six) are avaialble, I will create those calculations. But I want show in a good visualizations for those dynamic time periods with couple of measures.

Thanks & Regards

KV

• ###### 1. Re: calculations for Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg in single Axis

Hi KV,

I think you'll be more likely to get help if you attach a Tableau Packaged Workbook showing what you've tried so far. Right now your request isn't really asking for help as much as it's asking for someone else to do the work for you.

• ###### 2. Re: calculations for Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg in single Axis

Hello Tom,

Its not like that, I am expecting different visualizations approaches for this type of raw data from experts in our community. I have already done my calculations in sheet5 and implemented for Last six months count from today dynamically. Also I want the Last 3months average and Last 6 months Average in same logic, means under May I have required these two fields as labels along with the count.

I need to this multiple measures and want to show in different type graphs. I

I am able to achieve the Last six months along with the data dynamically in chart. These two logics are able to calculate individually,However I am not able to combine Last 3 Months Avg and Last 6 Months avg with the Last six months in same Axis. Can you any body please guide on this.

Thanks.

KV

• ###### 3. Re: calculations for Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg in single Axis

Hello Tom,

Do you have time? can you please help the logic to implement all together in a single work sheet.

Thanks & Regards

KV