Using filters on a SQL created chart

[Dirk De Mal]

Hi there,

Rather new to Analytics so wondering if the community can give me a helping hand. I've created a pure SQL chart in Analytics and was wondering if it would be possible to create filters on that chart in my dashboard?

I've tried controls but with no succes so far.

Any help would be appreciated.

Kind regards,

Dirk

[Inder Singh · Accepted solution]

@Dirk De Mal Do you mean you want to create filters on the dashboard that can filter the data in the SQL-created chart? If yes, then you can read about how to do that here: https://support.atlassian.com/analytics/docs/use-variable-controls-for-interactive-filtering/ 

[Dirk De Mal]

Hi @Inder Singh ,

Yes...I need to be able to do some filtering on  a pure created SQL. I went through the documentation, but was unable to find the correct approach.

Any help would be much appreciated.

Kind regards,

Dirk

[Inder Singh]

@Dirk De Mal Where are you stuck at? As an example if you have a dropdown control named PROJECT_TYPE created on the dashboard, you can include this in the SQL WHERE clause as shown below:

SELECT COUNT(DISTINCT `Jira Issue`.`issue_id`) AS `Count of distinct Issue Id`

FROM `jira _issue` AS `Jira Issue` INNER JOIN `jira_project` AS `Jira Project` ON `Jira Project`.`project_id` = `Jira Issue`.`project_id`

WHERE `Jira Project`.`project_type` = {PROJECT_TYPE}

[Dirk De Mal]

Hi @Inder Singh 

Got it...Big thx for the help.

Kind regards,

Dirk