Forum Discussion

Isha's avatar
Isha
Frequent Visitor
10 years ago
Solved

Consolidate data for creating visualization

Hi,   I am using an excel based testing metrics to track the day of testing (Sprint _execution_ Date) and status for the test cases executed on that day(Sprint_status). These sprints repeat as and ...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Isha

     

    I think the very first thing in your case is to re-model the dataset.

    Table 2 = 
UNION (
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_33_Execution_Date],
        'Table'[Sprint 33 Status]
    ),"Sprint_Excute","33 Exection"),
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_34_Execution_Date],
        'Table'[Sprint 34 Status]
    ),"Sprint_Excute","34 Exection"),
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_35_Execution_Date],
        'Table'[Sprint 35 Status]
    ),"Sprint_Excute","35 Exection")
)

     

    Then your questions would be much easier.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

Isha

 

I think the very first thing in your case is to re-model the dataset.

Table 2 = 
UNION (
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_33_Execution_Date],
        'Table'[Sprint 33 Status]
    ),"Sprint_Excute","33 Exection"),
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_34_Execution_Date],
        'Table'[Sprint 34 Status]
    ),"Sprint_Excute","34 Exection"),
    ADDCOLUMNS(ALL (
        'Table'[Application],
        'Table'[Test Case #],
        'Table'[_Sprint_35_Execution_Date],
        'Table'[Sprint 35 Status]
    ),"Sprint_Excute","35 Exection")
)

 

Then your questions would be much easier.

  • Isha's avatar
    Isha
    Frequent Visitor
    10 years ago

    Thanks Eric. I will try this solution and let you know. Like you suggested,  making the table single-dimensional will help me in this scenario.