Explore recipe: Joining attributes

Return to top

5 Comments

  • Hannah Voice

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

    0
  • 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?

     

     

    0
  • 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!

     

    0
  • 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!

     

    Abby

    0
  • 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. 

    0

Please sign in to leave a comment.

Powered by Zendesk