cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Locken Frequent Visitor
Frequent Visitor

Using maximum percentage from cumulative data

Hi all,

 

I'm having an issue with a graph I'm trying to create for a client's dashboard. For context I've just completed a project where I've been doing multiple tests per day during the assignment. What I'm trying to do is create a line graph using imported Excel data to show the planned execution dates along the X axis and the target % of tests executed on the Y axis.

 

The problem we're having is that because there's multiple target percentages assigned to each day, the best option we can find so far for plotting the graph is having the percentage as an average, which causes the maximum value to fall below 100% due to the fact that there's multiple values per day. For example, the last day of testing was November 29th, but there was 10 tests on that day, so the cumulative % on that day is being divided by 10, leading to an average of 98.7% of tests executed as our maximum value on the Y axis.

 

Is there a way to plot this data as it is, or will I need to alter it so that it's more like total number of tests run per day?

1 ACCEPTED SOLUTION

Accepted Solutions
Locken Frequent Visitor
Frequent Visitor

Re: Using maximum percentage from cumulative data

It's all good, my colleague figured out a workaround whereby he created a separate table of dates then used measures/relationships to plot the graph properly. Thanks anyway Smiley Happy

4 REPLIES 4
tringuyenminh92 New Contributor
New Contributor

Re: Using maximum percentage from cumulative data

Hi @Locken,

 

I'm trying to understand your situation, could you please describe by 1-2 pictures(data structure or fields, current sample data) with 1-2 picture expectations?, so it will be easier to understand and quickly propose solution for you.

 

Locken Frequent Visitor
Frequent Visitor

Re: Using maximum percentage from cumulative data

Sure thing, the data I'm using looks like this (finishing on 29 November 2016 with Planned % at 100):

 

PowerBI1.PNG

 

The graph I've managed to produce thus far looks like this (note the final date of 29th Nov has 98.7%):

 

PowerBI2.PNG

 

Ultimately I want to be able to plot the actual test execution progress against the planned execution dates, so it looks akin to this:

 

PowerBI3.PNG

 

Thanks for the reply

tringuyenminh92 New Contributor
New Contributor

Re: Using maximum percentage from cumulative data

Hi @Locken,

 

Sorry for late response, i just finished dinner after work. As my understand, Cummulative tests is Actual data, so how to calculated the target % ?  and The Planned % is manually input or should re-calculated from some fields?

 

Locken Frequent Visitor
Frequent Visitor

Re: Using maximum percentage from cumulative data

It's all good, my colleague figured out a workaround whereby he created a separate table of dates then used measures/relationships to plot the graph properly. Thanks anyway Smiley Happy