• Graeme Carmichael

  • 2020年04月23日 10:00

  Community Moderator

  Mrunal

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

• Mrunal Dadhi

  • 2020年04月23日 10:15

  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?

  

• Graeme Carmichael

  • 2020年04月23日 10:21

  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.

• Niharika Gaur

  • 2020年04月23日 12:17

  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

• Graeme Carmichael

  • 2020年04月23日 14:06

  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.

   

• Graeme Carmichael

  • 2020年04月23日 20:29

  Community Moderator

  Niharika

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

  \d{6}
  
  

  Hope that helps. 

• Niharika Gaur

  • 2020年04月24日 06:33

  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

• Niharika Gaur

  • 2020年04月24日 06:44

  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

• Graeme Carmichael

  • 2020年04月24日 06:52

  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.

• Niharika Gaur

  • 2020年04月24日 06:57

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

  Regards,

  Niharika

   

サインインしてコメントを残してください。