Highlight selection from a table in multiple charts

#1

Hello everyone,

I am trying to create a dashboard, and I would kindly ask for some tips on how I can accomplish the following functionality.

I have a table where the users can click on to check information of a particular parameter, let’s say $studentname$. I also have multiple charts with information about students, for example, a histogram presenting their age, another chart with their grades, and so on. I would need the user to click on the $studentname$ in a table, and as a result, the charts would highlight the student information. It should not filter but highlight only.
In summary, the table is used as a selection to highlight members in multiple charts.
Thank you!

#2

There is a built in way to do this they cal it Brush View Parameter.
https://www.dundas.com/Support/learning/documentation/create-view-content/design-overview section 2.5 on the menu at top right click Parameters.
If it is not working automatically, ask these questions:
did you delete the parameter?
do all the metric sets come from the same data, can Dundas auto detect that student from data source A is same as from data source B?
I have never opened or needed to open the brush view parameter but you can and modify it so it does what you want (just before you do check in all your other work so if you need to you can undo all the changes, I suggest making a copy and playing around in the copy before working on the main one.)

2 Likes
#3

Thank you James Davis, your comment helped me a lot.
Working with Brush View Parameter is gonna me help to achieve what I want.
Still related to this questions, do you know how I can change the color of the highlight?
I cannot find where to change the hover over color highlight for a chart.
Thank you.

#4

I think that is in chart itself. that would not be controlled by the brush param.
It depends on the visual on the hover highlight, like on a bar chart you go in on the data point then the look tab and find selected coloring I think.
Maybe @jeff has a video on this or can tell us now then make a video later.

#5

Sadly, I don’t have a video talking about the Brush view parameter but i do have a nice one that helps Demystify parameters in general!

As for controlling the colour - it depends on the visualization that you are using but every visual has some sort of ‘hover color’ property.

Here it is on a table - Hover Over Color

image
image.png375×1165 23.8 KB

#6

Hi gents. Thank you for all suggestions, but I am now back to the original question.

“How can I highlight common members in different charts (dashboards in containers)?”

The brush parameter view helped me to a certain point, but I had to apply containers to call the dashboards dynamically, and this way, the brush parameter doesn’t work.

chart1.control.series[0].getPoint(0,2).fill = brush;

This example above is similar to what I need to do, but instead of using getPoint, I need to inform the color change based on the uniqueName from a table field. The uniquenName in the table is the same one that generated the bar chart column. Maybe there is a method that I can use to get the series coordinates through the uniqueName of a field, but my JS is very limited to figure it out on my own, and I need your help, please.

#7

Hi @diegomelo , no scripting needed.
Each dashboard has its own brush view parameter, so when setting up the filter interaction on the table, if you choose the “Brush View Parameter” listed in the dialog it’s only for the current dashboard. To brush the dashboards in containers, you can create a view parameter yourself in the Parameters window and connect it to the brush view parameters of the dashboard.
image

#8

Hi @jay.gong,
I tried as you suggested but I am getting the charts filtered while using the “Brush View Parameter”.
What I need is only the highlight without filtering. I mean click on a field in a table and change its state in all charts.
By working this way the dashboard will enable the end-user to see its selection highlighted and most important than that compare with others.
Here is an example of what I am trying to accomplish. One user is selected.

Example
Example.png824×661 19.4 KB
.

Is that possible to achieve without scripting?
If scripting is needed, do you have an example?
Please @jay.gong, or @jeff

Thank you!

#9

@diegomelo It should only highlight and not do any filtering if it’s configured correctly.

There are a few things to check. In the table’s hover/or click event, if you add a filter interaction did you setup the parameter mapping correctly like this?
image

Also, in the embedded dashboard, make sure the brush parameter is NOT linked to any metricset, so it would only do brushing and not filtering.

If you need further assistance, can you send an email to support@dundas.com so we can open a formal support ticket and go from there.

#10

Hi @jay.gong, thank you for your comments.
The Brush View Parameter worked, but not as I expected.
When I click on the table the charts get highlighted, which is good. However, the same click updates the dashboards on each container, and as consequence the highlight disappear. That happens very fast.
I tried changing the order of the events but the Brush View Parameter is always happening first.
Do you have any suggestion on how to set the Brush View Parameter up to happen after the dashboards get loaded in the containers?
Thank you very much!