Explore recipe: Joining attributes

Return to top


  • Hannah Voice

    Oh that's awesome @..., that works a treat. Thanks so much! 🤩

  • Florian W

    I have used this one to create an attribute:

    [Ticket solved - Year]+" "+[Ticket solved - Month]

    In my Report (X-Axis) it's shown as, e.g. "2020 September".

    I would like it to appear as, e.g. "2020-09" or "2020-Sep"

    How can I do that?



  • Julie Mathevet

    Hey Florian,

    For the format 2020-09, you could use the following formula : [Ticket solved - Year]+"-"+ DATE_FORMAT([Ticket solved - Date],"MM")

    For the format 2020-Sep, you could use this one: [Ticket solved - Year]+"-"+ LEFTPART([Ticket solved - Month],3)

    What could be tricky with this second example is that the years will be correctly ordered (chronologically), but not the months (it will follow an alphabetical order).

    So if you wish to use this format 2020-Sep, I recommend to create an Ordered Set attribute based on this joined attribute.

    This way you’ll be able to manually order the values so they are in a Chronological order. See this article: Organizing values by groups and sets 

    Hope this helps!


  • Abby Armada

    Hi there,

    We have a Custom Field (Plan Type) that has 4 options, and I want to combine two of them ("Null" and "No Account"). How would I go about doing that? Thanks!



  • Gab Guinto
    Zendesk Customer Care

    Hi Abby,

    You can organize the values thru a custom group attribute (see Creating groups) based on your custom field attribute. You may aggregate results from these two field options; when you use this custom group attribute in your query, the count for 'Null' and 'No Account' will be combined into one attribute value. 

  • Patrik Kaldi

    Hi Everyone,

    I would create a custom attribute where I would join 2 different form's attributes . 

    We have 2 form one has got 6 priority level the other has got the standard 3 level . How could I connect them to use only the 3 level of priority instead of different values ? 

    Thank you in advance,


  • Gab Guinto
    Zendesk Customer Care
    Hi Patriarch,
    You can try creating a custom attribute with IF THEN ELSE statements referencing your two priority fields. Example:
    IF [Priority field A]="Priority 1A" OR [Priority field A]="Priority 2A" OR [Priority field B]="Priority X" THEN "Priority Z"
    ELIF ...
    You can refer to this article to read more about the IF THEN ELSE function.
    Thanks Patriarch!

Please sign in to leave a comment.

Powered by Zendesk