Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Time in status (PowerBI connector for jira)

Paulina Carvajal Muñoz
Contributor
August 10, 2022

Hola! Estoy haciendo un dashboard para mi empresa en PowerBI y necesito ayuda para comprender algunas columnas de la tabla TimeInStatus. Hay algunas cosas que no logro comprender, por ejemplo:

- Las columnas "Duration in business days 24h" y "Duration in business days BH" en que medida se encuentran? No logro hacer la conexión o conversión entre estas y las que están con formato de hora, minuto y segundo. Ya que debería ser lo mismo pero en un formato o medida diferente, pero no entiendo las que no tienen unidad de medida..

- Por otro lado, no entiendo que significa "BH" y su diferencia con las otras columnas, igualmente todas tienen valores diferentes entonces no se identificar que está representando cada una.

Su ayuda porfavor!

Muchas gracias

 

Captura de pantalla 2022-08-10 103026.png

Captura de pantalla 2022-08-10 103402.png Captura de pantalla 2022-08-10 103307.png

2 answers

1 accepted

0 votes
Answer accepted
Liubov Topchyi
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 10, 2022

Hello Paulina @Paulina Carvajal Muñoz ,

 

DURATION_IN_NORMAL_HOURS - counts the duration for the whole calendar period including nonworking days (24h per 7 days a week). Time is shown in seconds

DURATION_IN_NORMAL_HOURS_FORMATTED - the same as above but seconds are formatted to show hours/minutes/seconds

 

DURATION_IN_BUSINESS_DAYS_BH - counts the duration for the business week (5 working days, 8h per day). Time is shown in seconds

DURATION_IN_BUSINESS_DAYS_BH_FORMATTED - the same as above but seconds are formatted to show hours/minutes/seconds

 

There are some clues directly in the connector configuration:

image (9).png

Hope this helps.

Regards,

Luba

0 votes
Andrea Pareja
Contributor
August 23, 2024

Hola @Paulina Carvajal Muñoz 

Quiero crear un dashboard con la metrica de Time in Status. Puedes explicarme cómo lo hiciste?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events