Explore recipe: Joining attributes

Have more questions? Submit a request

5 Comments

  • Andrei Kamarouski
    Comment actions Permalink

    Hi, 
    How do I get months following the real calendar order with this joined attribute Year/month (now they get by alphabet)? 

    0
  • Molly
    Comment actions Permalink

    Hey Andrei,

    When combining the attributes like so, Explore sees it as a string and not as a time attribute. My recommendation for looking at the Year/Month in order would be to stack the attributes like so:

    1
  • Andrei Kamarouski
    Comment actions Permalink

    Hi Molly, 
    This is clear. Thank you! 

    0
  • Jason Brown
    Comment actions Permalink

    Hello,

    I am trying to combine fields where sometimes one is null, is there any way to detect if its null and if so, replace it with a different value so that the result is not "Null"?

     

    0
  • Mike P
    Comment actions Permalink

    The combined attribute in the example breaks sorting:

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

    If you use it, August will be before March.

     

    Instead, you can use 

    DATE_FORMAT([Ticket created - Timestamp],"yyyy-MM")

    using this one the X axis will (still) be sorted properly.


    But it breaks many date-based filters.
    So if you select to show results for "this year" and use the DATE_FORMAT combined attribute (instead of adding Year and Month separately), December of previous year will also appear on the chart, and will appear with zero tickets (or whatever you are measuring).

     

    0

Please sign in to leave a comment.

Powered by Zendesk