Forum Discussion
Compare values from same column
Hi chaps
Done some reading on similar threads but not finding the right solution for my need, so posting a new thread.
data model, see link
Test Details column contains the results from 2 test runs (but there are more in a similar format), one from 15/08/2019_14:38 and another from 15/08/2019_17:17
The Transaction name contains 68 unique page tests where the average response time is captured in Average response time column.
What I’m looking to do is build in a method to add a new column for every transaction name value, that will list the difference between the results and output a value of "higher" or "lower" if the most recent test run is higher or lower than the one it is being compare to. I was hoping the use the Matrix visual for this because I am able to list comparisons of transaction name by short test detail with values of average response time.
https://docs.google.com/spreadsheets/d/1abKdNcVWUgEMOUYwPAxlxm2dX87XdEFZkBBcNy-k5wA/edit#gid=0
4 Replies
Hi etwa702 ,
I'm a little confused about your desired output based on your data sample.
I was hoping the use the Matrix visual for this because I am able to list comparisons of transaction name by short test detail with values of average response time.If it is convenient, could describe your logic in details and share your desired output so that we could help further on it?
Best Regards,
Cherry
just a bump on this question please guys.
Thanks!
etwa702 wrote:hey there, thanks for the response.
See below an example and my powerbi report.
v-piga-msft I described (i hope) my situation a little better in terms of what I want to achieve in my earlier post.
Any chance to help me out, I'm bashing my head over here!
Thanks.
