Forum Discussion

fcoalcantarajr's avatar
fcoalcantarajr
Frequent Visitor
3 years ago
Solved

PowerBI CycleTimeDays average and Azure DevOps Cycle Time widget does not return me the same number

Hi y'all. I have been trying to build a panel using PowerBi that includes the CycleTimeDays average for a project. I've followed this tutorial step-by-step: Lead time and Cycle time sample Power BI r...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI fcoalcantarajr,

    I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.

    Regards,

    Xiaoxin Sheng

fcoalcantarajr's avatar
fcoalcantarajr
Frequent Visitor
3 years ago

Hi Anonymous 

I didn't quite get your message, sorry. =(

But yes, the data is not static, it keeps changing. The source is a Feed OData connection with Azure Boards.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI fcoalcantarajr,

I mean if the line chart and card visual get the same result, it means the expression should worked and equally to the default aggregation effect. The difference results may due to the underlying data source records changes.

Regards,

Xiaoxin Sheng

  • fcoalcantarajr's avatar
    fcoalcantarajr
    Frequent Visitor
    2 years ago

    Hi, the line chart and card visual sometimes get the same result, but not always. Sometimes it returns wildly different results.

    For example, these values are for the same organization. Filters were setup correctly.