Run reports based on conditions in dashboard sections

Question

Hi

I have read few articles on the web but for some reason I did not understand how they can serve what I need...hoping you can shed more lights specifically to my requirement.

I want to create 3 different analyses, (analysis A, analysis B, analysis C)  each one has different columns, and I want to use one set of prompts such as division (EMEA, NAMER, APAC, LAD, JAPAN) and country but here is when I want the 3 reports to appear:

When I select EMEA, NAMER, APAC & LAD then Analysis A to appears

When I select JAPAN then Analysis B to appears

When I select APAC AND any of the following countries in APAC such as KR, TW IN then Analysis C appears

Any idea on how it can be done.

Thanks

Joe

Gianni Ceresa · Answer

Hi Joe,

You can do it by using conditions to show or hide sections in your dashboard.

You dashboard page will contains 3 sections with one single analysis per section, you must create 3 analysis acting as conditions.

The conditions to display or hide a section is not based on the content of the analysis for only on the row count. So your analysis acting as conditions must return at least one row when "OK" and nothing when "NOT OK", you do that by setting filters with your rules (for example "prompted division IN (EMEA, NAMER, APAC & LAD)" => at least one row of result etc.).

And it's done

The key element to keep in mind is that a condition on a section only works on the row count of an analysis and not the values returned, so the analysis you use as a condition must have the right filter to return rows when OK and nothing when not OK.