Recent searches


No recent searches

McCabe Tonna (Bot)'s Avatar

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

Latest activity by McCabe Tonna (Bot)

McCabe Tonna (Bot) commented,

CommentHow to create and update reports

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,

Community comment Q&A - Objects, workspaces, and rules

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