Interactive Filter not working on Dashboard Report

[bharath10]

Greetings, Masters,

i have created report for Software by Locations, and added to Dashboard.

i want to see result from report for a specific software OR some softwares (currently unable to select multiple software ) which is used/installed across/different locations.

i enable Interactive filter for 'Software Location Graph' report and have added interactive filter widget to filter software records but when i tried to see result for any random software, Graph/value of software on graph is not changing/updating as per my selection in Interactive Filter. 

It constant same, and not taking values from my selection from Interactive Filter. 

London, Table use for report - cmdb_software_instance, Type of report - bar (group by locations, stack by Class)

1. Why interactive filter is not working here. &  

2. How can i add multiple softwares, are same time from different publisher. example - MS office, Adobe Reader

Any suggestion, solution on this.

Thanks in advance. 

Bharat

[Alberto Consonn]

Hi,

have a look at the article below, it will clarify your doubts:

String type fields are not showing in Reference Interactive filter hierarchy

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Jeff66]

Be sure you set the report widget to follow the interactive filter:

 

[bharath10]

Thank You Alberto.

Trying to create new interactive filter for report publish on dashboard. getting below error- 

Reference field "product_result.product" is not of type "cmdb_sam_sw_install"

Report getting data from table -cmdb_sam_sw_install

and same table i am using while creating Interactive filter in reference and in related list. but it throw and error.

Error during selecting table in relate list of interactive filter.

Thanks 

Bharat

[Aaron Munoz]

Maybe you're supposed to use table cmdb_ci_spkg instead of cmdb_sam_sw_install as your source. Table cmdb_software_instance has reference the field software, which points to cmdb_ci_spkg.