Skip to main content
New Idea

Improve analytics functions and operators

Related products:Freshdesk
  • January 31, 2024
  • 0 replies
  • 17 views

ken-proradis
Apprentice
Forum|alt.badge.img

I liked the possibility to create custom fields and functions in Freshdesk Analytics, but I like to suggest some pretty basic improvements.

Even though I can subtract values, it is impossible to make operations on negative values.

I can't use ADD_DATE(Created date, -7).

 

One other thing I tried is to create a "Quarter" field like:
CONCAT(YEAR(Created date), "Q", CEIL(MONTH(Created date) / 3))

Analytics doesn't allow to convert integer to string.