some questions

[#1]

Dear All,

First, I would like to make a first tab showing just the status of some KPI's. When I try to make my expression (a simple average) relative to show a gauge based on one of the values of a dimension I cannot. Is there a way around this? which function might do this. ( I used so far: IF(KPI_ID='KPI1', Avg (Percentage)) but then he states their are no values to be shown.)

thanks,

k

[swuehl · Accepted solution]

Not sure if this is your problem, but try to put your if() inside your aggregation:

= Avg( if( KPI_ID='KPI11', Percentage))

or using set expression

= Avg( {<KPI_ID = {KPI11}>} Percentage)

[#3]

thanks a lot