Description of problem: I have a dashboard with 2 bar charts (NVD3) using distinct datasources (SQL). Both have a column named "Test". When I select a bar from the first chart, the second chart is updated, but the filter is wrong. If I use the filter in the left side, the bug doesn't occurs. Version-Release number of selected component (if applicable): 6.2 (trunk) How reproducible: Steps to Reproduce: 1. Add two bar charts to the dashboard, using distinct data-sources. Both datasources must have columns in common. 2. Click in a bar from the first chart. Actual results: Data is shown wrong, messed. Expected results: Data is shown correctly Additional info: The bug only occurs if I filter from the chart. Using the filter on the left side, bug don't occurs.
Please use the admin user to export the dashboard and workspace. Should have files with the following extensions: (workspace) .kpiex (dashboard) .cex
Created attachment 977041 [details] Workspace and Dashboards Workspace and Dashboard files attached
Are these files from DV 6.0 dashboard?
Why I ask are these from DV 6.0, because when I export dashboard and export workspace, I don't get a workspace like this.
Walter, Can you test with DV 6.1 to see if your issues are resolved? There have been many improvements in Dashboard Builder. Thanks. Van
Van, I tested with the master branch of github. It is the 6.1? I forked the code and fixed it. I don't think mine solution is the best, but worked for me. You could take a look at: https://github.com/walteram/dashboard-builder/commit/fc6d294054486b1c6d638a1a3c18ffe8ac133702
We're using version 6.0.3. Also, I'll need to post this BZ to the BRMS BAM component so that they can apply the change.
Dashboard builder QE has seen a similar issue. Not sure if it will get patched on its 6.2 release.
Posted by David on the BPM BZ: The expected filtering behaviour is the following: 1.- User can define "shared" properties across several data set providers. Basically, a property with the same id. at least in two different data providers. 2.- If we are building a dashboard which refers to two or more data providers containing shared properties and we try to filter by a shared property then any of the KPIs containing such property will be filtered. 3.- Shared properties can be useful for implementing "join" like filter behaviour which allows for filtering several KPIs belonging to different data providers to filter at the same time. 4.- We can disable the join like behaviour above just by adjusting the property ids on the data provider column definition screen. We must ensure the property ids are unique and do not clash between data provider definitions. The example described by @Jan is working as expected. However, if we do not want the People KPI to be filtered then we can proceed as #4, change the Car's age property to f.i: "carAge". Doing so we differentiate between the Car's age and the People's age. The current implementation it covers a wide range of scenarios. Changing the underlying implementation can be problematic and hard to implement. We do not recommend it. One additional thing we can do is to add a section to the user documentation to clarify how this feature works, similar to the above explanation.
Thanks. I have added a new topic ("Dashboard Builder Filters") to the Admin Guide, containing the information outline above.