Forum Discussion

etwa702's avatar
etwa702
Frequent Visitor
6 years ago
Solved

Comapring Number Values from same column with text values from same column

Hi all BIHelp  Greg_Deckler    I need some help please.   Some background for context.   - We are running a project for a in house web app we have created. The Web app consists of multiple tr...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    See above

etwa702's avatar
etwa702
Frequent Visitor
6 years ago

WOW, this looks great!

 

Just saw this on my dataset and I love it.

 

i did notice that based on my data there are some Test Runs that did not have a result for the Transaction name, must be because that test did not test that page.

 

Example, OCT build tested 10 pages only and SEP build tested all 13 pages, SEP build would have a value and based on that then states that it is the winning build and it should instead not show any calculation.

 

Possible to help me with filtering out the blank values?

 

Thank you for this, great help!!!

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi etwa702 ,

OK, created a new measure "...Revised" That wrapped "Winning Build with an if statement. So just compare the two and make the change.  You could if you wish define the granularity even more, and add another if to determine whether it is "Sept Test not performed."

 

Glad I could help!

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

Winning Build Revised = IF( ISBLANK([Sep Final]) || ISBLANK([Oct Final]),"Test not Performed", IF([Oct Final]>[Sep Final], "Oct Final" , If([Sep Final]>[Oct Final],"Sept Final","SAME Result")))

 

 

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Tested on page 2