Multiple filters in dashboards/widgets

[oana5]

Hi everyone,

I would like to filter the information in dashboards by multiple filters, simultaneously. We need the dashboard to be dynamic. For example, I want to see the information filtered by Client, Priority, Team and User.

Step 1: I customize the dashboard as breakdown dashboard and select Client as a breakdown.

Step 2: If I create a widget - type time series, I am allowed to add 2 breakdowns (in this example, Priority and Team), but then I have to select the elements used for filtering. (for example Priority Low and Team - Team1)

Aren't we able to select just Priority and then, to see all the combinations between Priority and Team?  

Step 3: I cannot split the information by User.

Is there any type of widget (or even report) I could use to filter information by all the breakdowns above mentioned?

Please let me know if there is a way to do this.

Many thanks in advance,

Oana

[ankitmathur]

Hello Oana,

I have the same question, let me know if you are able to figure out something. Thanks!

Regards,

Ankit Mathur

[oana5]

Hi Ankit Mathur,

Thank you for your message. I did not find anything by now. I've tried to use different conditions, types of widgets, reports but I do not obtain the charts I would like to see.

The solution I see now would be to create an ODBC connection and use Excel/Power Query to create the dashboards.

What do you think?

Best regards,

Oana