TOTAL IN BAR CHART

[#1]

How can I Show the Count as a Text on a Bar Chart. My expression is  

if((NumberYes/NumberQuestions)<0.858,(NumberYes/NumberQuestions))

I am getting the right number of Bars for example I have 36 Bars.

I wanna display the 36 as a Text box somewhere on the Bar Chart.

I have tried the Followung expression in the Presentation Tab->Text in chart and it works only if you select a Bar. Any Ideas??

if((NumberYes/NumberQuestions)<0.858,Count(Total DISTINCT location_id))

[alexandros17]

in presentation -> text in chart, insert your expression then press ok

now press shift +ctrl and move the text where you need

[#3]

Already Tried that

[#4]

Hi Ray,

what is your dimension of the chart. Lets call it Dim.

Then this should work:

. . ., Aggr(Count(Total DISTINCT location_id), Dim) )

RR

[#5]

It works better,atleast I am getting the number now, but I need the count with a condition like below

if((NumberYes/NumberQuestions)<0.858,Count(Total DISTINCT location_id))

[jerem1234 · Accepted solution]

Try this:

count(distinct if(aggr((NumberYes/NumberQuestions), location_id)<0.858,  location_id))

Hope this helps!

[MK_QSL]

Try this...

if((NumberYes/NumberQuestions)<0.858,Count(DISTINCT location_id))

[stevedark]

I would have thought the issue is that there is no aggregation on the two values in the division, should it not be something like:

if((sum(NumberYes)/sum(NumberQuestions))<0.858,Count(DISTINCT location_id))

Previously without a single bar selected there would have been multiple values for each of those figures and so they would have been returning NULL.

Steve

[#9]

That works, now one more question, The numer 0.858 in the above expression is a Hard coded number I wanna replace it with  AVG(NumberYes/NumberQuestions).

I know we cant do the Avg under Aggr

[stevedark]

I would put it in a variable and refer to it in your expression.

Create a variable vAvgQuestions, with the content:

=AVG(NumberYes/NumberQuestions)

You can then use it in your expression like this:

count(distinct if(aggr((NumberYes/NumberQuestions), location_id)<$(vAvgQuestions),  location_id))

I think I missed your initial question, are you trying to count how many bars are under the average?

Cheers

Steve