Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to calculate Average for non-numeric fields

I have 1 year Jira data which has all the Bugs, Builds, Tasks (Issue_type) for each Project. Now i need to calculate the Average number of bugs for project in Quarter 1, Quarter 2, Quarter 3 Quarter ...
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    1. You need a 1-to-many relationship between the Quarter table (shown right) and the data table (shown left) thru Project name

    2. Place QuarterTable[Quarter] in the rows of a matrix visual

    3. Place this measure in the visual:

    Measure =
DIVIDE (
    CALCULATE ( COUNTROWS ( Table1 ), Table1[issue type] = "Bug" ),
    DISTINCTCOUNT( Table1[Project Name] )
)

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous 

1. You need a 1-to-many relationship between the Quarter table (shown right) and the data table (shown left) thru Project name

2. Place QuarterTable[Quarter] in the rows of a matrix visual

3. Place this measure in the visual:

Measure =
DIVIDE (
    CALCULATE ( COUNTROWS ( Table1 ), Table1[issue type] = "Bug" ),
    DISTINCTCOUNT( Table1[Project Name] )
)

Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

Cheers  Datanaut