We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to Filters 2 variables within same (Values) Column in Widgets Pivot as either (OR)

Thread ID:

Created:

Updated:

Platform:

Replies:

141575 Dec 18,2018 06:55 PM UTC Dec 19,2018 07:34 AM UTC Dashboard Platform 2
loading
Tags: Dashboard Designer
Hidzir Adam
Asked On December 18, 2018 06:55 PM UTC

Hi Support Teams,

I tried to filter in value setting  2 variables names  in same Values Column using Widgets Pivot, the Result I get is both filter is consider as 'AND' but how about if i need my result to display either anyone of the (filter) conditions is TRUE it will list the results.


Thank You Very Much,


Best Regards,

Hidzir Adam
Kuala Lumpur,


Attachment: hidziradam_696fe5a4.zip

Suriya [Syncfusion]
Replied On December 19, 2018 07:28 AM UTC

Hi Hidzir, 
 
The Widget level filters treated with “AND” operation between selected values and it will return the result which satisfy all the applied filter condition.  
 
We suggest you to use Data source filters. Here you can specify your filter condition as AND, OR, AND NOT and OR NOT. 
 
To configure Data source filters kindly follow below steps, 
  1. Click Data source filter icon in design canvas,
 
  1. Filter window will appears as below. Click “Add” button to add filters,
 
 
  1. Here you can add n number of filters using filter condition just as below,
 
 
  1. Click “Update” button to update the filter window. To know more about data source filters kindly refer below documentation link, https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-data-filters
 
  1. And then you can use the column in your widget to get filtered data.
 
Regards, 
Suriya 


Hidzir Adam
Replied On December 19, 2018 07:34 AM UTC

Hi Suriya ,

Thank You very much for your prompt reply and suggestions. I will amend my Data Source to get desire result.

Best Regards,

Hidzir Adam
Kuala Lumpur

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon