nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using filters on a SQL created chart

Dirk De Mal_3mqsr2

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

Accepted answers

Inder Singh

@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/

All comments

Inder Singh

Dirk De Mal_3mqsr2

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_3mqsr2

Hi @Inder Singh

Got it...Big thx for the help.

Kind regards,

Dirk

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

analytics

filters