help with chart and expression

[#1]

Hi,

We have a app (attached) which is recording a log of work my team does. We have the following expression on a pie chart which works fine (number tally up).

({<[Inform business decisions?]= {'Yes'}>} [Inform business decisions?])/Count(TOTAL [Inform business decisions?)

However, for a gauge chart (next to it) it won't work. There is 693 records and 37 that have informed business decisions so % is 6.2%.

Can anyone advise on what the expression and settings will be on the gauge chart so it works? Also can you please advise on the expression in 'text in chart' so the 6.23% show correctly (currently 0.6228956228)..my current expression was this and it doesn't work:

Num(Count({<[Inform business decisions?] = {'Yes'}>} [Inform business decisions?]), '#.##0%')  

Chris

[Clever_Anjos]

Go to Presentation Tab

Set Min = 0 and Max = 1

[#3]

Hi,

Cheers - that has fixed gauge in that % is showing on the bar, but this doesnt fix 'text in chart' expression or why the top end of the scale isn't showing (100%).

[Clever_Anjos · Accepted solution]

Text in char :

=num(Count({<[Inform business decisions?]= {'Yes'}>} [Inform business decisions?])/Count(TOTAL [Inform business decisions?]),'#,##0.00%')

100%, change to 6 Major units