Galina Skovorodnikova

@... thank you so much! Not sure how I've missed that article but it's exactly what I need. Thank you!

Hello,

I can't figure out how to create a custom calculated attribute to show bugs reported by platforms. E.g. to find all bugs reported for the web app, I need to show tickets with two tags at the same time "bug" and "web". 

When I use a condition with only one tag, it works properly (but gives inaccurate results). As soon as I add a second tag condition (the formula is accepted), it breaks and stops showing the category.

This version (with one tag) works (but it also includes tickets that are not bugs):

IF ([Ticket tags]="web") THEN "Web app bugs"

ELIF ([Ticket tags]="mac") THEN "macOS app bugs" 

ELIF ([Ticket tags]="win_10") THEN "Windows 10 app bugs" 

ELIF ([Ticket tags]="ios") THEN "iOS app bugs" 

ELIF ([Ticket tags]="android") THEN "Android app bugs" 

ENDIF

 When I add a second tag (I tried different ways), nothing works:

IF ([Ticket tags]="web" AND “bug”) THEN "Web app bugs"

ELIF ([Ticket tags]="mac" AND “bug”) THEN "macOS app bugs" 

ELIF ([Ticket tags]="win_10" AND “bug”) THEN "Windows 10 app bugs" 

ELIF ([Ticket tags]="ios" AND “bug”) THEN "iOS app bugs" 

ELIF ([Ticket tags]="android" AND “bug”) THEN "Android app bugs" 

ENDIF

neither:

IF (([Ticket tags]="web" AND ([Ticket tags]=“bug”)) THEN "Web app bugs"

ELIF (([Ticket tags]="mac" AND ([Ticket tags]=“bug”))  THEN "macOS app bugs" 

ELIF (([Ticket tags]="win_10" AND ([Ticket tags]=“bug”))  THEN "Windows 10 app bugs" 

ELIF (([Ticket tags]="ios" AND ([Ticket tags]=“bug”)) THEN "iOS app bugs" 

ELIF (([Ticket tags]="android" AND ([Ticket tags]=“bug”))  THEN "Android app bugs" 

ENDIF

I would appreciate any help! Thank you!

Hi Taylor,

Thank you so much! This is exactly what I need! I really appreciate your help.

Hello,

I would like to get the number of tickets created last month (that is easy to do) but also compare it against the monthly average number of created tickets (based on the last 12 months) - show it as a trendline.

How to get the monthly average number of tickets created (over the last 12 months)? 

1) I tried to create a Date range calculated metric first (for 12 months in the past)

2) Then created a Standard calculated metric: divided the metric from above by 12 (months).

I get an error "Only partial results are visible for this query because the underlying SQL query returns more than 50,000 rows. To limit performance issues, each delegated SQL query is restricted to 50,000 rows" and the trendline shows some crazy numbers (in millions).

Would appreciate any help. Thank you!