[Canned Reports] Create visualisation on question with filters

[mahalakshme]

AC:

• Users should be able to see count of individuals registered for each subject type in the form of bar chart. Do not include the voided individuals.
• X-axis should have the name of subject type and Y-axis the count of registrations
• Should be able to filter with start and end date which should be based on registration_date in individual table

Technical suggestions:

Metabase api link

Approximate payload that might work - Not tested:

POST /api/card
Authorization: Bearer <your_api_token>

{
  "name": "Sales Data with Date Filters",
  "dataset_query": {
    "type": "native",
    "native": {
      "query": "SELECT date, SUM(sales) AS total_sales FROM sales_table WHERE date BETWEEN {{start_date}} AND {{end_date}} GROUP BY date ORDER BY date",
      "template-tags": {
        "start_date": {
          "id": "c53df913",
          "name": "start_date",
          "display_name": "Start Date",
          "type": "date",
          "default": "2023-01-01"  // Optional default value
        },
        "end_date": {
          "id": "c82df913",
          "name": "end_date",
          "display_name": "End Date",
          "type": "date",
          "default": "2023-12-31"  // Optional default value
        }
      }
    },
    "database": 1  // Replace with your database ID
  },
  "display": "bar",  // Visualization type
  "visualization_settings": {
    "x_axis.title": "Date",
    "y_axis.title": "Total Sales",
    "graph.line_style": "solid"
  },
  "collection_id": null  // Add to a collection if needed
}

Inputs-Ignore-for analysis purpose and later reference:

• paste the chart here
• line chart over bar chart - intelligently - every line will be subject type
• metabase, dataogram - ODK and metabase -> absolute, and then trend, display data below that

[ombhardwajj]

Please assign it to me @mahalakshme !