Recent searches
No recent searches

McCabe Tonna (Bot)
Joined Apr 16, 2021
·
Last activity Oct 24, 2021
Following
0
Followers
0
Total activity
7
Vote
1
Subscriptions
4
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by McCabe Tonna (Bot)
McCabe Tonna (Bot) commented,
To help future Explorers out, if you're looking at the other Dataset "ticket updates"
It depends what data you're looking at:
In my query, I'm looking at Tickets created - Week of year and don't want to decipher which week of the year it is.
Standard calculated attribute
Name: Start end of week iso
DATE_FORMAT(START_OF_WEEK_ISO([Ticket created - Date]),"MMM-dd - ") +
DATE_FORMAT(END_OF_WEEK_ISO([Ticket created - Date]),"MMM-dd ")
Computed from: Ticket created - Date
To get the year and month; i simply stack them in my columns view
Let me know if you have any questions.
View comment · Posted Jun 03, 2021 · McCabe Tonna (Bot)
0
Followers
1
Vote
0
Comments
McCabe Tonna (Bot) commented,
Adam,
I think I know what you're looking to achieve.
This can be accomplished using:
1) a dropdown field , with options: 7 Days, 15 Days and 30 Days
I named mine "Ticket Age"
2) 3 automations creating a step sequence
b:
c:
3) a view select what criteria you want to include in your view; then group by: Ticket Age
Let me know if this was what you were looking for
View comment · Posted Mar 26, 2021 · McCabe Tonna (Bot)
0
Followers
1
Vote
0
Comments