Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks



------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

​I tried too and there is *no such option for "Dselect All" and it's pain to deselect them one by one individually.

Thanks,
Sudhakar

------------------------------
Sudhakar Chappidi
------------------------------

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

That is a bummer, but I guess we can shrug it off as a "first release" gap in functionality.  I know it's not equivalent, but I've been using the Filter features in Dashboard widgets, and I really like the fact that they have an "Invert" option, so you select the one or two items you want to EXCLUDE, click the Invert checkbox, and you're there.  Perhaps a short-term workaround is look at possibly delivering your info via a dashboard?

------------------------------
Albert Valdez
albert@intelalytics.com
------------------------------

Original Message:
Sent: Sun April 26, 2020 10:14 PM
From: Sudhakar Chappidi
Subject: Data Table Filter

​I tried too and there is *no such option for "Dselect All" and it's pain to deselect them one by one individually.

Thanks,
Sudhakar

------------------------------
Sudhakar Chappidi

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi Stoyka,
You are correct. There should be a way to deselect all. We are working on making this available for the next phase of improvements. Thank you for the feedback.

------------------------------
RACHEL SU
------------------------------

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner
------------------------------

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU
------------------------------

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU
------------------------------

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Thank you! That's great.

Is there any reason why we can't change query source for a data table and have to recreate data table afresh?

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Wed June 03, 2020 07:51 AM
From: RACHEL SU
Subject: Data Table Filter

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi @RACHEL SU, 

I have report using Tabs as custom control. In one of the tab, I am using iframe to refer to Data Table. If I navigate to this tab immediately, iframe loads correctly Data Table; however, if I don't go to Tab with Data table for some time, it doesn't render Data Table. 

Do you know what can be done ​to troubleshoot this further?

I have seen similar behavior with Active report and always have to copy list to other reports instead of using reference due to this issue.

Thanks!

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Wed June 03, 2020 09:40 AM
From: Buddhi Gupta
Subject: Data Table Filter

Thank you! That's great.

Is there any reason why we can't change query source for a data table and have to recreate data table afresh?

------------------------------
Buddhi Gupta

Original Message:
Sent: Wed June 03, 2020 07:51 AM
From: RACHEL SU
Subject: Data Table Filter

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi Buddhi,

Data table not loading should be logged with Support. I think dev should investigate this issue further.

Rachel

------------------------------
RACHEL SU
------------------------------

Original Message:
Sent: Thu June 04, 2020 12:13 PM
From: Buddhi Gupta
Subject: Data Table Filter

Hi @RACHEL SU, 

I have report using Tabs as custom control. In one of the tab, I am using iframe to refer to Data Table. If I navigate to this tab immediately, iframe loads correctly Data Table; however, if I don't go to Tab with Data table for some time, it doesn't render Data Table. 

Do you know what can be done ​to troubleshoot this further?

I have seen similar behavior with Active report and always have to copy list to other reports instead of using reference due to this issue.

Thanks!

------------------------------
Buddhi Gupta

Original Message:
Sent: Wed June 03, 2020 09:40 AM
From: Buddhi Gupta
Subject: Data Table Filter

Thank you! That's great.

Is there any reason why we can't change query source for a data table and have to recreate data table afresh?

------------------------------
Buddhi Gupta

Original Message:
Sent: Wed June 03, 2020 07:51 AM
From: RACHEL SU
Subject: Data Table Filter

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi @RACHEL SU, 

We have requirement to keep top most Category open by default and ​rest collapsed. Is it possible to change it in same Data Table or planned to add control over this feature by "Show Top10 group open"?

Also, if there is no need to scroll, can we hide scrollbar? 

Thanks for inputs!

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Wed June 03, 2020 07:51 AM
From: RACHEL SU
Subject: Data Table Filter

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson

Hi Buddhi,

We have the option to specify the initial expand/collapse state, but not for specific category. The plan is to be able to save expand/collapse state when the author saves the report. That should satisfy your usecase.
When no need to scroll, the scrollbar still present is not ideal. We are looking for ways to disable it but this may not be in the product any time soon.

Rachel Su

------------------------------
RACHEL SU
------------------------------

Original Message:
Sent: Fri June 05, 2020 10:44 AM
From: Buddhi Gupta
Subject: Data Table Filter

Hi @RACHEL SU, 

We have requirement to keep top most Category open by default and ​rest collapsed. Is it possible to change it in same Data Table or planned to add control over this feature by "Show Top10 group open"?

Also, if there is no need to scroll, can we hide scrollbar? 

Thanks for inputs!

------------------------------
Buddhi Gupta

Original Message:
Sent: Wed June 03, 2020 07:51 AM
From: RACHEL SU
Subject: Data Table Filter

Hi Buddhi,

We are adding the option to deselect all in the filter drop down for 11.1.7.

------------------------------
RACHEL SU

Original Message:
Sent: Tue June 02, 2020 06:08 PM
From: Buddhi Gupta
Subject: Data Table Filter

Do we have a way to know which all issues are fixed in CA 11.1.7 for Data Tables? Thanks for inputs.

------------------------------
Buddhi Gupta

Original Message:
Sent: Mon May 25, 2020 09:27 AM
From: RACHEL SU
Subject: Data Table Filter

Thanks for submitting the idea. For https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754,
Number 3, the overall data table size doesn't change dynamically but you can change the table height when authoring.
Number 4, you should be able to use custom column header text instead of the default one from data source. The property is called Column title label and it's available when the column title is selected. Hope this helps.
​

------------------------------
RACHEL SU

Original Message:
Sent: Fri May 22, 2020 08:56 PM
From: Jo Marie Sellner
Subject: Data Table Filter

I created a new idea for suggested changes to data tables, https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2754 please vote for it and add comments about things you would like to see changed.​

------------------------------
Jo Marie Sellner

Original Message:
Sent: Sun April 26, 2020 10:49 AM
From: Stoyka Bojkova
Subject: Data Table Filter

Hi I just try the new data table in 11.1.6 but i am facing one big issue.

When running the table and have the output in HTML if the user click on the filter of one of the columns he can search for item but once found this item can only be deselected. So if i have a list of 200 countries and i want to filter to see only 1 or 2 i need to deselect all the others one by one. I can not deselect all of them and then filter only the one i need. 
Is this known behavior or am i doing something wrong?

thanks

if i select Belgium i get Belgium but i can only deselect it

If i deselect it its changing the value to exclude Belgium. 

------------------------------
Stoyka Bojkova
------------------------------

#CognosAnalyticswithWatson