最近搜索
没有最近搜索

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
评论