Skip to main content
Atlassian Logo
  • Apps
  • Documentation
  • Resources
  • Contact us
  • Sign in
  • Sign in
Atlassian Analytics
Atlassian Analytics Cloud

Documentation

  • Get started with Atlassian Analytics
    • Add Atlassian Analytics to an existing site
    • Who can query data and create charts?
  • Connect your data to Atlassian Analytics
    • Learn about data sources in Atlassian Analytics
      • What is a data source?
      • What is the Atlassian Data Lake?
    • Understand the data model of the Atlassian Data Lake
      • Schema for organization data
      • Schema for Jira family of products
      • Schema for Jira
      • Schema for DevOps data
      • Schema for Jira Service Management
      • Schema for asset and configuration management
      • Schema for operations in Jira Service Management
      • Schema for Confluence
      • Schema for Talent
      • Schema for Focus
      • Schema for Goals
      • Schema for Atlassian Projects
    • Connect directly to a data source
      • Connect to the Atlassian Data Lake
      • Connect to Jira Align Enterprise Insights
      • Connect to a third-party data source
      • Connect to Databricks
      • Connect to Google BigQuery
      • Connect to Google Sheets
      • Connect to MySQL
      • Connect to PostgreSQL
      • Connect to Snowflake
    • Manage your data sources
      • General data source settings
      • Edit data source connection details
      • Data source time zone support
      • Disconnect a data source
    • Manage and customize your schemas
      • Add a schema
      • Edit a schema
      • Column properties
      • Sync schemas
      • Create custom tables and columns
      • Edit custom tables and columns
      • Use custom tables and columns
      • Connect your tables with foreign keys
      • Track changes on your schema
    • Manage and monitor your queries
      • Resolve schema differences in your queries
      • Search your queries
      • When are queries sent to a data source?
    • Monitor your data source performance and usage
      • What is the query log?
      • View your data source usage
  • Explore dashboard templates
    • Create custom dashboard templates
      • Publish a dashboard as a template
      • Make changes to a custom dashboard template
      • Delete a custom dashboard template
    • Dashboard templates for Jira
      • "Cross-team DevOps effectiveness scorecard" template
      • "Cross-team effectiveness scorecard" dashboard template
      • “Flow metrics (Jira work types view)” dashboard template
      • “Flow metrics (work items view)” dashboard template
      • "Multiple sprints overview" dashboard template
      • "Organization DevOps effectiveness scorecard" template
      • “Organization effectiveness scorecard” dashboard template
      • “Organization overview” dashboard template
      • “Overview” dashboard template
      • “Project overview” dashboard template
      • “Simple project overview” dashboard template
      • "Single sprint overview" dashboard template
      • "Team DevOps effectiveness scorecard" dashboard template
      • “Team effectiveness scorecard” dashboard template
      • "Time in current status" dashboard template
      • "Time-in-status history" dashboard template
      • “Work overview” dashboard template
    • Dashboard templates for Jira Service Management
      • “Change management overview” dashboard template
      • “Incident management overview” dashboard template
      • “Request management overview” dashboard template
      • Dashboard templates for service desk scorecards
    • Dashboard templates for asset and configuration management
      • “Reports for assets” dashboard template
    • Dashboard templates for operations data
      • “Alert analytics” dashboard template
      • “Alert MTTA/C statistics of teams” dashboard template
      • “Alert statistics for the month” dashboard template
      • “Incident analytics” dashboard template
      • “Notification statistics” dashboard template
    • Dashboard templates for Confluence
      • “Adoption” dashboard template
      • "Content management" dashboard template
      • "Content restrictions" dashboard template
    • Dashboard templates for Jira Align Enterprise Insights
      • “Epic status” dashboard template
      • “Portfolio financials” dashboard template
      • “Portfolio flow metrics” dashboard template
      • “Solution flow metrics” dashboard template
      • “Value stream flow metrics” dashboard template
  • Visualize your data in Atlassian Analytics
    • Navigate Atlassian Analytics
      • Home page
      • Navigation for Atlassian Analytics
    • Build dashboards to analyze data
      • Dashboard layout
      • Create or copy a dashboard
      • Archive, delete, or restore a dashboard
      • Dashboard elements
      • Arrange elements on your dashboard
      • Dashboard settings
      • Organize your dashboards
      • Manage activity on your dashboard
      • Examples for cache duration
    • Create charts on your dashboard
      • Create a chart
      • What is the chart editor?
      • Data limits for charts
    • Customize your charts
      • Chart types
      • Area chart settings
      • Bar chart settings
      • Bar line chart settings
      • Box plot chart settings
      • Bubble chart settings
      • Bubble map chart settings
      • Bullet chart settings
      • Funnel chart settings
      • Heat map chart settings
      • Line chart settings
      • Map chart settings
      • Pie chart settings
      • Scatter plot chart settings
      • Single value chart settings
      • Single value indicator chart settings
      • Table chart settings
      • Custom date formatting
    • Manage charts on your dashboards
      • Edit a chart
      • Copy or delete a chart
      • Move a chart
      • Monitor chart performance
      • Refresh and examine chart data
      • Can dashboard viewers explore chart data?
    • Use variables for dynamic filtering
      • What are variables?
      • Relative date variables
      • Date and time functions for variables
    • Use controls for interactive filtering
      • Control types
      • Set up a “Calendar” control
      • Set up a “Date bucket” control
      • Set up a “Date slider” control
      • Set up a “Dropdown” control
      • Set up a “Hidden variable” control
      • Set up a “Range input” control
      • Set up a “Text input” control
      • What is the control editor?
      • Manage controls
      • Connect a control outside of a query in Visual SQL
      • Use charts as controls
      • Use wildcards in a “Text input” control
    • Get chart insights using Atlassian Intelligence
  • Query and transform data with Visual SQL
    • Learn about Visual SQL
      • What is Visual SQL?
      • Visual SQL steps
      • Create and manage Visual SQL steps
      • Group and aggregate functions
      • Operators for filter conditions
      • Guided formulas
      • Custom formulas
      • Write custom formulas using Atlassian Intelligence
      • SQLite date and time functions
      • SQLite string functions
      • Keyboard shortcuts
    • Use visual mode to create a query in Visual SQL
      • What is visual mode?
      • Add or remove columns
      • Add or remove query filters
      • Preview your schema in visual mode
      • Sort and limit the rows of your visual mode query
      • Edit the join path of your visual mode query
      • What are the generated and executed queries for visual mode?
    • Use SQL mode to create a query in Visual SQL
      • What is SQL mode?
      • Use Atlassian Intelligence to generate SQL queries
      • Preview your schema in SQL mode
      • Use and edit variables
      • What is the executed query for SQL mode?
      • Use SQL history for version control
      • SQL editor settings
      • Restricted SQL commands
    • Merge your query data
      • Merge queries
      • Join types
  • Collaborate on and share dashboards
    • Collaborate on dashboards
      • Comment on individual charts
      • Comment on dashboards
      • Who receives comment notifications?
      • Change when you receive email notifications for comments
    • Share charts and dashboards
      • Share charts
      • Share dashboards
      • Set up dashboard subscriptions
  • Manage permissions in Atlassian Analytics
    • Manage permissions at the data source level
      • Data source permissions
      • Manage data source access
    • Manage permissions at the dashboard level
      • Dashboard permissions
      • Manage dashboard access
  • Connect your Atlassian data to third-party tools
    • What is a data share?
    • Create a data share
    • Create and manage credentials for a data share
    • Connect your data share to your environments and tools
    • Edit data selection of a data share
    • Rename or delete a data share
    • Track activity on a data share
    • Understand the data model of data shares
      • Metadata columns in data shares
      • Data share schema for organization data
      • Data share schema for Jira family of products
  • Administer your Atlassian Analytics workspace
    • Workspace settings
  1. Atlassian Support
  2. Atlassian Analytics
  3. Resources
  4. Visualize your data in Atlassian Analytics

Use variables for dynamic filtering

  • What are variables?

    Learn more about the three types of variables and where you can use them.

  • Relative date variables

    View the list of available relative date variables you can use to filter dates dynamically.

  • Date and time functions for variables

    View the list of functions you can apply to date and time variables.

Was this helpful?

Still need help?

The Atlassian Community is here for you.
Ask the Community
  • Explore more
  • What are variables?
  • Relative date variables
  • Date and time functions for variables
  • Visualize your data in Atlassian Analytics
  • Customize your charts
  • Manage charts on your dashboards
  • Use variables for dynamic filtering

  • Use controls for interactive filtering
  • Get chart insights using Atlassian Intelligence
CommunityQuestions, discussions, and articles
Atlassian Logo
  • Accessibility
  • Notice at Collection
  • Privacy Policy
  • Terms of Use
  • Security
  • 2025 Atlassian