Merge two columns name in the chart legend

KReporter
1

Hello @maretval,

We have kreport with the column chart & it has the legends in the side.

We want to add new filed in report by using Formula (For example, {field1}.-.{field2}).

The field1 are all numbers, but field2 has text and we want to consider only first 3 alphabets of the field2. How do we do it in the kreporter?

2

No worries, we found the solution.

{field1}.’ - ‘.substr({field2},0,2)