Pesquisas recentes
Sem pesquisas recentes

Galina Skovorodnikova
Entrou em 15 de abr. de 2021
·
Última atividade em 28 de dez. de 2023
Seguindo
0
Seguidores
0
Atividade total
8
Votos
1
Assinaturas
3
VISÃO GERAL DA ATIVIDADE
MEDALHAS
ARTIGOS
PUBLICAÇÕES
COMENTÁRIOS NA COMUNIDADE
COMENTÁRIOS EM ARTIGOS
VISÃO GERAL DA ATIVIDADE
Atividade mais recente por Galina Skovorodnikova
Galina Skovorodnikova comentou,
@... thank you so much! Not sure how I've missed that article but it's exactly what I need. Thank you!
Exibir comentário · Publicado 29 de mar. de 2021 · Galina Skovorodnikova
0
Seguidores
0
Votos
0
Comentários
Galina Skovorodnikova criou uma publicação,
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!
Publicado 26 de mar. de 2021 · Galina Skovorodnikova
1
Seguidor
2
Votos
2
Comentários
Galina Skovorodnikova comentou,
Hi Taylor,
Thank you so much! This is exactly what I need! I really appreciate your help.
Exibir comentário · Publicado 14 de jan. de 2021 · Galina Skovorodnikova
0
Seguidores
1
Votos
0
Comentários
Galina Skovorodnikova criou uma publicação,
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!
Publicado 14 de jan. de 2021 · Galina Skovorodnikova
0
Seguidores
2
Votos
2
Comentários