Master chart effect other charts if i select prat of it

Mohammad Al Taj shared this question 20 months ago
Answered

Hi All, I need to create master chart to effect other charts if i select prat of it,any help please ?

ef973d077c49e03a8e598b21f3a685f9

Thanks

Best Answer
photo

Hi Mohammad,

Thank you for reaching out. I think what you may be looking to do is chart brushing. Brushing allows users to restrict results in their chart by choosing to Include or Exclude certain areas. This is an interactive method of filtering, as the user defines what they want to see or remove by highlighting the particular area on their chart and can be linked to other reports in the dashboard, so that the filtering is applied to other charts on the dashboard.

As you can see in the following screenshots, after brushing the Agency Sales by Profitability report to Include only a few of the total values, the values on the other reports on the dashboard change to reflect the chosen filters:

cf2d47cd5d24cac842c5f04e7ab26f87

To accomplish this, a decent amount of setup is involved.

First, other reports on your dashboard must make use of filters. Once this is the case, click on 'Edit' from your dashboard tab and click on 'Analytic Setup' and choose the reports you want linked.

3ff4bdbdabdc2f530521b0eb37c0168d

In my example, I went into Agency Sales by Profitability, turned on Link Chart Brushing, clicked into the corresponding reports, and linked the report to an existing In List filter called Company Name (if you open/maximize the Campaign Summary report from our Ski Team tutorial data Campaign Analysis dashboard, you'll see this filter), that is featured in another report on my dashboard:

c973cd0241d199cfdc76a06cfb22ba27

You can find an in-depth overview of the Analytic Setup, including several videos, here, so that you can setup your dashboard to accomplish this. More information on brushing, including a video, can also be found on our Wiki page.

Let me know if this is what you were looking for.

Thanks,

Mike

Comments (1)

photo
1

Hi Mohammad,

Thank you for reaching out. I think what you may be looking to do is chart brushing. Brushing allows users to restrict results in their chart by choosing to Include or Exclude certain areas. This is an interactive method of filtering, as the user defines what they want to see or remove by highlighting the particular area on their chart and can be linked to other reports in the dashboard, so that the filtering is applied to other charts on the dashboard.

As you can see in the following screenshots, after brushing the Agency Sales by Profitability report to Include only a few of the total values, the values on the other reports on the dashboard change to reflect the chosen filters:

cf2d47cd5d24cac842c5f04e7ab26f87

To accomplish this, a decent amount of setup is involved.

First, other reports on your dashboard must make use of filters. Once this is the case, click on 'Edit' from your dashboard tab and click on 'Analytic Setup' and choose the reports you want linked.

3ff4bdbdabdc2f530521b0eb37c0168d

In my example, I went into Agency Sales by Profitability, turned on Link Chart Brushing, clicked into the corresponding reports, and linked the report to an existing In List filter called Company Name (if you open/maximize the Campaign Summary report from our Ski Team tutorial data Campaign Analysis dashboard, you'll see this filter), that is featured in another report on my dashboard:

c973cd0241d199cfdc76a06cfb22ba27

You can find an in-depth overview of the Analytic Setup, including several videos, here, so that you can setup your dashboard to accomplish this. More information on brushing, including a video, can also be found on our Wiki page.

Let me know if this is what you were looking for.

Thanks,

Mike

photo
1

Yes Mike this is what I m looking for....... I will do my homework now and update you :) .


Thanks

photo
1

Hi Mohammed,

That's great! I look forward to your response.

Regards,

Mike

photo
1

Thanks Mike i did that and its working fine :) ......

photo
1

Hi Mahammad,

Perfect! Happy to help. I'll go ahead and mark this as Answered. Please don't hesitate to reach out with further questions or concerns.

Regards,

Mike

photo