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?
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.
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))
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.
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 ..
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".