Numeric custom form field is not available in export query when visualization type is table

10 댓글

  • Graeme Carmichael
    Community Moderator

    Mrunal

    Because your custom field is numeric, it will appear under the metrics section rather than the rows section.

    0
  • Mrunal Dadhi

    Thank you Graeme Carmichael for the response but we don't want to do any operations on that field. Is there any way to add it through Metrics but not doing any arithmetic operations on it?

    0
  • Graeme Carmichael
    Community Moderator

    Mrunal

    You must use an aggregate on a metric.

    However, if you are including the ticket ID as part of your table output, then using SUM will always comeback to the expected value.

    The alternative is to abandon your numeric field and use a single line text field instead. In that case the custom field will be available under Rows and Columns and would be useful if you are reporting on that field across multiple tickets.

    0
  • Niharika Gaur

    Hi Graeme,

    There must be some way to add numeric field type in the report?

    We have Order number field that is 6 digit order number. We don't want that as text type it should be numeric because then if that field is filled with an incorrect format like instead of 345763 agent filled that field as 345A63, then it will affect the reporting and approval of refund for that order number.

    Thanks,

    Niharika

    0
  • Graeme Carmichael
    Community Moderator

    Niharika

    It is quite common for fields that appear numerical to be text if it represents a reference that is unlikely to be summed or unlikely to be used in a mathematical expression.

    If you have the ticket ID in the table, it should still display as expected with a SUM, MIN or MAX aggregate.

    To validate a field and ensure it always contains only numbers, use a Regex ticket field type.

    I'll ask how to validate that, it should be straightforward.

     

    1
  • Graeme Carmichael
    Community Moderator

    Niharika

    Moderator Kay kindly provided the magic code for 6 numeric characters as:

    \d{6}

    Hope that helps. 

    0
  • Niharika Gaur

    Hi Graeme,

    Thanks. This will help us. I have another question, Can we put a maximum limit on any type of field. Like I created a new field and it should allow on 6 numeric digits, not more than that. Is that possible in ticket field to put a minimum and maximum limit?

     

    Thanks,

    Niharika

    0
  • Niharika Gaur

    Hi Graeme,

     

    I figure out that.

    If I put regular exp as \b[0-9]{6}\b as this it limited me till 6 digits like 546789 after that it gives the error.

    Let me know if I am doing this right?

    Thank you again,

    Niharika

    0
  • Graeme Carmichael
    Community Moderator

    Niharika

    I am really no Regex expert, but I believe you can use:

    \d{3,6}

    Where 3 is the minimum number and 6 is the maximum number of numerical characters. 

    I hope that helps.

    0
  • Niharika Gaur

    That's great! Thank you so much, Graeme.

    Regards,

    Niharika

     

    0

댓글을 남기려면 로그인하세요.

Zendesk 제공