Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Example -
Table 1:
Col1,
Col2,
Col3
Table 2:
Col4,
Col5,
Col6
both tables are not related but column significance is same. In straight table chart how to merge both tables data and show.
am looking for a output like below
col1/col4(col1 & col4 values to be merged and shown in single column) col2/col5 col3/col6
My requirement does not allow me to do this at the script level and has to be on the presentation layer.
Can anyone help??
hello
what do you want ?
one total line with sum of each column pair
one row per row on input table ? in this case, is there a way to match lines together ?
Merging means? concatenating the columns in chart?
You could do something like this?
LinkedColumn:
Load Col1 & '/' & Col4 as Col1_Col4,
Col2 & '/' & Col5 as Col2_Col5,
Col3 & '/' & Col6 as Col3_Col6
Apologies. Just saw that you could not do it in script.
You can however use similar logic in the UI.
You can add a calculated dimension and use the script from above. For example:
= Col1 & '/' Col4
You can then label it as Col1/Col4 or whatever you like in the label prompt box.