Ranking in a Textbox

[#1]

Hello

i curretnly have a chart the Dimension I have used is Opendatemonth, the expression is Count(distinct incidentid). this gives me a count of incidents in each month.

I wish to write a comment below this table stating :

the highest volume of incidents this year were in '....'

Where '...' is the month form the field opendatemonth with the higheest count of incidentids.

Can anyone help please?

Jon

[shumailh]

Hi Jon,

I think you can use the Chart Title for this purpose, if you are not using it. When your chart is active just press [CTRL] + [SHIFT] then you can move/ re-size the sub objects of chart. You can use the chart title for this purpose.

Make sure in your "chart properties---> General Tab--- > Show Title in Chart" should be checked.

Regards,
Shumail Hussain

[#3]

Hello

Sorry i need to do this in a separate text box. And need sto be active (i.e change for diofferent selection criteria0.

jon

[#4]

Hi,

Attached is a workaround solution to your query ...

[Anonymous]

A little add-on to Umang Jain's document. If you change the straight table to a bar chart for example you can add the following expression under Chart Properties > Presentation > Text in chart, to have it as text in the chart:

='Month with highest sales: ' & maxstring(aggr(if(rank(sum(Sale))=1, Month),Month))

[shumailh]

Thanks Johannes, I never tried "Text in chart" before. Gud 1

Best part is this option is very comprehensive we can define the angle, alignment etc.

Regards,
Shumail Hussain

[#7]

Hi Johannes - you taught me something new today thanks ..... 🙂

However a small query ... when I try an use this feature only a part of the text is visible and the remaining stays hidden .... am I missing something here ..

[#8]

Hi Jain,

If i understood your question properly, you can activate your chart by clicking on chart and just press [CTRL] + [SHIFT] then you can move/ re-size the "Text in chart".

- Kevin

[#9]

Thanks Kevin ...