Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
try using set analysis like this for airfare:
sum( {<Type={airfare}>} price) / count( {<Type={airfare}>} price)
Hope this helps
Tobias
gauge only needs an expression, so maybe (replace with name of your fields and upper/lowercase)
avg ({$ <type={airfare}>} expenses)
sum({<[Expense Type]={Airfare (Employee Ticket Only)}>}[Travel Expense])/count({<[Expense Type]={Airfare (Employee Ticket Only)}>})
Current expression won't work
Hi,
use:
sum({<[Expense Type]={'Airfare (Employee Ticket Only)'}>} [Travel Expense] )/count({<[Expense Type]={'Airfare (Employee Ticket Only)'}>}[Travel Expense])
Tobias
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?