최근 검색


최근 검색 없음

Denis Iliev's Avatar

Denis Iliev

가입한 날짜: 2024년 1월 05일

·

마지막 활동: 2024년 8월 02일

팔로잉

0

팔로워

0

총 활동 수

6

투표

1

플랜 수

2

활동 개요

님의 최근 활동 Denis Iliev

Denis Iliev님이 에 댓글을 입력함

댓글Metrics, attributes, and filters

I need assistance with creating report:

A report that shows users who have provided an email address for feedback and have not had contact with technical support in the past year. Here’s what I’ve tried so far:

I created a date filter to include tickets from the past year.

I attempted to create a metric with a standard calculation using the following formula:

sql

IF (DATE([Ticket created - Year]) = (DATE("today") - 1 year)) THEN [Requester email] ENDIF

However, I keep encountering a syntax error. I then tried this formula:

sql

IF [ticket created - Year] <= today() - 364 THEN [requester email] ENDIF

But I received this error:

“You can’t use [Ticket created - Year] as a number and TODAY() - 364 as text. Use only numbers or only text. If necessary, use the NUMBER function to transform text to numbers.”

Any help or suggestions would be greatly appreciated. Thank you in advance!

댓글 보기 · 2024년 8월 02일에 게시됨 · Denis Iliev

0

팔로워

0

투표 수

0

댓글


Denis Iliev님이 에 댓글을 입력함

댓글End users and organizations

Thank you for your response. I would like to inquire if there is a method to create a custom field that functions similarly to the system-provided "Email" field, specifically intended for feedback purposes. The objective is to restrict entries within this custom field to be exclusively in the format of an email address (e.g., example@site.com) and disallow any other text input.

댓글 보기 · 2024년 1월 09일에 게시됨 · Denis Iliev

0

팔로워

0

투표 수

0

댓글


Denis Iliev님이 에 댓글을 입력함

댓글End users and organizations

Hello! We are currently using a custom field categorized as "text" instead of "email" within the user data input section. However, we have noticed that this element doesn’t provide clarity to our users regarding its purpose. Instead, it might confuse them about the requirements for entering an email address, which is intended for feedback purposes.

We would like to edit or add clarification to this built-in "Email" field to make its purpose clearer for our users. Is it possible to perform this edit? We aim to introduce explanatory text alongside the field, guiding users on what is expected when filling in their email addresses.

댓글 보기 · 2024년 1월 05일에 편집됨 · Denis Iliev

0

팔로워

0

투표 수

0

댓글