Simple average calculation - Showing as a guage

[#1]

I have travel expenses by type of travel expense. Albeit  airfare, meals, rental...etc. I want the average priced paid for airfare. I need to know how to only select type equal to airfare and then perform the math of total Airfare / count of airfare type. I like to show it in a guage chart.

[tobias_klett]

Hi,

try using set analysis like this for airfare:

sum( {<Type={airfare}>} price) / count( {<Type={airfare}>} price)

Hope this helps

Tobias

[maxgro]

gauge only needs an expression, so maybe (replace with name of your fields and upper/lowercase)

avg ({$ <type={airfare}>} expenses)

[#4]

sum({<[Expense Type]={Airfare (Employee Ticket Only)}>}[Travel Expense])/count({<[Expense Type]={Airfare (Employee Ticket Only)}>})

Current expression won't work

[tobias_klett]

Hi,

use:

sum({<[Expense Type]={'Airfare (Employee Ticket Only)'}>} [Travel Expense] )/count({<[Expense Type]={'Airfare (Employee Ticket Only)'}>}[Travel Expense])

Tobias

[#6]

This worked but in the gauge chart I can’t get the avg price to appear and how do I get the minimum vale and maximum value to appear?