Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have the following situation:
my table does look like:
id | name | value | text |
1 | test1 | 10 | aa |
2 | test2 | 20 | aaa |
3 | test3 | 30 | aaaa |
4 | test1 | 40 | b |
5 | test2 | 50 | bb |
6 | test3 | 60 | bbb |
7 | test1 | 70 | c |
8 | test2 | 80 | cc |
9 | test3 | 90 | ccc |
10 | test1 | 100 | cccc |
i tried to implement this expression : Only({<name = {"test1"}>}text), but it does not work
my expected output is field: text: aa, b,c,cccc
i know i can solve this issue in script by clausel where name = 'test1', but i want to know, whether is possible within a chart: pivot, straightable.
Thanks a lot for any and all help
Beck
Hi, it does work!
Please see image below: I used the data you posted on Inline table and use a straight table to show the results.
could you try with..
sum({<name = {"test1"}>}value)
Hi,
Concat(Distinct {<name = {"test1"}>} text, ', ')
Hi Surenda,
i tried, but it does not work, i want see only text with values: aa, b,c,cccc on the base of name = test1
do you have any idea?
Beck
or you can try:
If(name = 'test1',only(text))
Hi Martines,
thanks for your feedback, but it does not work
Hi Carlos, thanks a lot for your feedback
but the same, it does not work
this expression should work
Concat(Distinct {<name = {"test1"}>} text, ', ')
Please share the sample data and expected output need
Hi, it does work!
Please see image below: I used the data you posted on Inline table and use a straight table to show the results.
Thanks a lot Carlos,
i misplaced a charakter , thanks a lot for your help