3 Replies Latest reply on Jul 27, 2016 11:43 AM by Andrew Watson

# Calculating Averages

Hello :

I've  300K transaction records of employees with  transaction identifier '1' or '0'. I want to show the average of transactions with '0' and '1' separately in a tool tip for a particular employee on a bar chart. How do I proceed ? if I use filters, I'm able to show the avg value of only a certain type for an employee.

Thanks

Nishanth

• ###### 1. Re: Calculating Averages

You can create calculated fields to work out the averages for 1 and 0.

Avg0: IF [ID] = 0 THEN [TRANSACTION] END

Avg1: IF [ID] = 1 THEN [TRANSACTION] END

These can be dragged to the Tooltip shelf and set to AVG.

This may too simplistic for what you're actually trying to achieve, in which case please upload a packaged workbook and include some specific examples of what you expect to see.

1 of 1 people found this helpful
• ###### 2. Re: Calculating Averages

Hi Andrew :

I forgot to mention that I'm showing the transactions of employees with '1' as their identifier by using a filter. But, in the tool tip I want to the averages of those with '0' too for that particular employee. I can show the avg for '1' in the way you mentioned above but I'm unable to show for '0' as they are being filtered out.

Thanks

Nishanth

• ###### 3. Re: Calculating Averages

Ok, if you're filtering out the data but also want to show it that complicates things. You could try converting the filter to a Table Calculation filter. This would mean creating a calculated field and having a formula such as ATTR([ID]) and using that calculated field as your filter instead of the ID field.

This may not work in your case, if not I suggest rethinking where you're going to put this information, would be better on a different worksheet which isn't affected by the Id filter so both 1 and 0 averages are always displayed.