최근 검색
최근 검색 없음

Aaron Henderson
가입한 날짜: 2021년 4월 17일
·
마지막 활동: 2021년 10월 24일
팔로잉
0
팔로워
0
총 활동 수
9
투표 수
4
플랜 수
3
활동 개요
배지
문서
게시물
커뮤니티 댓글
문서 댓글
활동 개요
님의 최근 활동 Aaron Henderson
Aaron Henderson님이 에 댓글을 입력함
Hi there,
Is it possible to use this formula to view ticket update week, by start of week? And for it to display based on individual updates and not the latest update? I used the below formula and am seeing some odd returns:
DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket updated - Date]),"YYYY-MM-dd")
I noticed some odd returns and the numbers not line up when I simply used "Update - Week of year". I added Ticket Update attributes on one card to see what would return. When I did that it returned the report below.
I did not expect to see multiple weeks of "Update - Week of year" within each "Ticket Updated Week by Start of Week". I drilled in to spot check some tickets and found that my created attribute was displaying the last time the ticket was updated, whether it was by the updater I am filtering for or not. The "Update - Date" and "Update - Week of Year" however correctly show the date/week the ticket was updated by the updaters.
Is this expected? Is there a way to display ticket update week by start of week instead of just week number? And it show based on individual updates and not the latest update?
Thanks,
Aaron
댓글 보기 · 2021년 3월 03일에 게시됨 · Aaron Henderson
0
팔로워
0
투표 수
0
댓글