Chart percent

[QSense]

Hi ,

I have chart . When I do not select any attribute Chart percent values are like 700.000 %,800.00% but after I have selected some attributes values become 70%,80%

Without any selection I want to see less than %100 values

my expression is =sum( AVAILABLE)/count(DISTINCT ID_SEGMENT_CLASS)

[Jason_Michaelides]

Click "Use advanced editor" on the top right of the reply box.

[QSense]

I attached

[jagannalla]

In Number Tab of chart properties -> Thousand Symbol ->  H.

Give a value as H.

Hope it helps you.

[QSense]

It only gives abbrevation for thousand I dont see more than %100 values without any selection

[QSense · Accepted solution]

=avg(aggr(sum(AVAILABLE)/count( distinct ID_SEGMENT_CLASS),ID_FLIGHT_NUMBER,DS_DATE_ORIGIN_YMD))