Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
suppose I used concat(distinct field1) and suppose this function returns 5 values (A,B,C,D,E)
I how can I get what is the fifth value from the concat function
is this possible or is there an alternative
please advise
=subfield(concat(distinct field1,'|'),'|',5)
how can get each value then
cause I'm trying to have a line chart with one dimension and n expressions N is maximum 5
and I want to make my five expressions be as dynamic as possible
because they will represent the available maximum 5 releases or the selected ones