Forum Discussion

tan_thiamhuat's avatar
tan_thiamhuat
Post Patron
1 year ago
Solved

Eventstream - Filter

Here, I filter the No_Bikes equal to zero, but why the EmptyRacks show its column to be non-zero?

  • Hi tan_thiamhuat ,

    Thank you for reaching out to the Fabric Community.

    suparnababu8 , has provided some helpful insights, but it seems the issue still persists.bao_phan  also shared their experience, which might be relevant in this case. Please review bao_phan  response, as it could offer additional guidance.

    We appreciate your valuable contributions to the community and thank you for continuing the discussion.

     

    Regards,

    Yugandhar.

  • Hi tan_thiamhuat ,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

     

    Thank You.

9 Replies

  • Hi tan_thiamhuat 

     

    It's becuase of you applied filer condition on No_Bikes equal to zero, it affecting the rows No_Bikes = 0 are removed, but other columns (as mentioned by you EmpyRacks) retain the original values. It doesn;t affect other columns presented in dataset.

     

    Thank you for asking this questions

     

    Did I answer your question? Mark my post as a solution!

    Proud to be a Super User!

    • tan_thiamhuat's avatar
      tan_thiamhuat
      Post Patron

      hur? I have thought that Filter works such that EmptyRack should show No_Bikes = 0, isn't that it should?

      • suparnababu8's avatar
        suparnababu8
        Super User

        Hi tan_thiamhuat 

         

        Oh Wonder🙂. I think there is lag to update the records. When you applied No_bikes=0, it should filter only that column. Now it's showing No_bikes column has 0 but empy racjs doesn't. 

         

        Thank you!

         

        Did I answer your question? Mark my post as a solution!

        Proud to be a Super User!

  • As my experience with EventStream, you should check the type of the column to make sure it is int (to do comparison with 0). Should refresh or re-run the EventStream again and wait for their result. Please update the situation so that I can help you more.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support

    Hi tan_thiamhuat ,

    Thank you for reaching out to the Fabric Community.

    suparnababu8 , has provided some helpful insights, but it seems the issue still persists.bao_phan  also shared their experience, which might be relevant in this case. Please review bao_phan  response, as it could offer additional guidance.

    We appreciate your valuable contributions to the community and thank you for continuing the discussion.

     

    Regards,

    Yugandhar.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support

    Hi tan_thiamhuat ,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

     

    Thank You.