Skip to main content

Notifications

Power Apps - AI Builder
Unanswered

Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

(0) ShareShare
ReportReport
Posted on by 23

I'm trying to set up a binary prediction as the number prediction just does nothing. It doesn't create the output columns in the table. 

 

But the binary prediction seems to want a Yes/No field. But a Yes/No field has a default value, so you end up with a value in every field by default. As a result there are no blanks to predict. 

 

So there is no way this can actually work is there?

 

 

Categories:
  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    Will a link to the model help? Power Apps | AI Builder - Models

  • Ashbhatia Profile Picture
    Ashbhatia on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    I'll come back to you on this 

  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    Here is a screenshot of some data. I am not giving it a lot, but it is giving me an r-squared of B so I assume it can predict something. But it is not writing the prediction into the prediction column?

  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    Yes the prediction column is a yes/no, and the outcome I am looking for is a yes/no. 

  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    It's now the next morning (Australia) and it publishes. I did not change anything overnight. 

     

    It has created a column called cr189_islateyesno - predicted (Prediction 18/11/20 but it has no values.

     

    My input column is IsLateYesNo and is a Yes/No field. It was edited in Excel and has some blank values in it. 

     

    However there has been nothing written into the prediction column?

  • Ashbhatia Profile Picture
    Ashbhatia on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    Can you share your data? or sample?

  • Ashbhatia Profile Picture
    Ashbhatia on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    Your output variable is yes/no? Based on your input data, you want to predict yes/no out column?

  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    And it won't publish. Of course. Does this AI Builder actually work? This thing seems really random. I have had issues with publishing before where it won't but the next day it does.

  • RyanADarby Profile Picture
    RyanADarby 23 on at
    Re: Binary prediction - surely it can't work if it needs a Y/N field as they default to a value?

    I figured it out. Lack of Dataverse knowledge. You can create a Yes/No but as long as you don't interact with the cell it won't default to a value. At least I have the model to the point of training. If it goes like it did for the numerical prediction it won't actually create columns with predictions, but I hope it will.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard