chart tittle show field name of cyclic group

[#1]

i've got a bar chart that has 2 dimensions, one is fixed and the other is a cyclic group. the group contains, e.g team and quarter,

so i want the chart title to show as 'xxxx count by quarter' or '... by team' depending on which is being looked at.

is this possible?

[#2 · Accepted solution]

Hi,

You can use GetCurrentField("Group Name").

Please revert back for any further query in this regard.

[#3]

just to further this slightly, would it be possible to display the label rather than the field name,

e.g. 'Quarter' rather than 'TRANS_START_QUARTER'

[#4]

No to my mind not possible to show the label. But there is an alternate solution which is as under:-

Pick(Match(GetCurrentField("Group Name"), 'TRANS_STRAT_QUARTER','TRANS_START_MONTH','TRANS_START_YEAR'), 'Quarter','Month','Year')

So as mentioned above you can create your own expression to convert the acutal field name to some descriptive label using Pick & Match functions.

[#5]

brilliant!

thanks again,

much neater than my if(Getcurrentfield(group) = 'TRANS....

solution was going to be!

Thanks DJ