Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Maybe:
count(distinct if(aggr((NumberYes/NumberQuestions), location_id)<$(=AVG(NumberYes/NumberQuestions)), location_id))
That works man, thnks