

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join two fields in one in Straight Table
Good Morning,
I have a table in which the name of one of the fields has been modified, since a historical table has the two fields, access_radio_on_air and access_radio_on_air_cobertura (these correspond to the field technical_name of the tasks table). Each of these fields has related three types of date, Planned, Forcast and Real and an SSP (provider). What I would need is that when generating the table in that specific case, concatenate the two fields in access_radio_on_air_coverage, but the other technical_name remain the same.
I've tried putting a type condition
=if((tasks.technical_name = "acceso_radio_on_air" or tasks.technical_name = "acceso_radio_on_air_cobertura"), "pepe", tasks.technical_name)
in the section of Dimensions / Settings for selected Dimension (with enable conditional) in the dimensiont technical_name and something similar in Expressions but for each of the dates and I can not do it.
Attached captures
Chart Properties/Dimensions/Used Dimenssions
Chart Properties/Expressions
I hope you can help me.
Thank you very much!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please post some sample data and your expected result.
thanks
regards
Marco


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I attach print scrints in the post but this is what i need:
In the top the 2 technical_name and below what i need, the union of the fields in one.
