Widget configuration examples

Below is an example of widget configuration

	"vulnerabilities_age": {
		ShowInGallery: true,
		Name:          "Issues Age Analysis",
		Description:   "Issues divided by age and severity",
		Labels:        []Category{CategoryApplicationSecurityPosture},
		Requirements:  []Requirement{},
		WidgetType:    WidgetDensityGrid,
		Queries: []Query{
			{
				Alias:  "density",
				Format: ResultFormatTable,
				Metric: NewMetricName("repo_branch_vulnerability"),
				Fields: []QueryField{
					{
						Name:       "last_found_at",
						FieldAlias: "$age",
						Func:       FuncDaysBetween,
						FuncArgs:   []string{"first_found_at"},
					},
					{
						Name:       "vulnerability_severity",
						FieldAlias: "label",
					},
					{
						Name:       "vulnerability_fingerprint",
						FieldAlias: "<7 days",
						AggFunc:    "count_distinct",
						Filter:     []Filter{{Field: "$age", Operator: OperatorLess, Values: []string{"7"}}},
						FuncArgs:   []string{"first_found_at"},
					},
					{
						Name:       "vulnerability_fingerprint",
						FieldAlias: "7-14 days",
						AggFunc:    "count_distinct",
						Filter:     []Filter{{Field: "$age", Operator: OperatorBetween, Values: []string{"7", "14"}}},
						FuncArgs:   []string{"first_found_at"},
					},
					{
						Name:       "vulnerability_fingerprint",
						FieldAlias: "14-30 days",
						AggFunc:    "count_distinct",
						Filter:     []Filter{{Field: "$age", Operator: OperatorBetween, Values: []string{"14.001", "30"}}},
						FuncArgs:   []string{"first_found_at"},
					},
					{
						Name:       "vulnerability_fingerprint",
						FieldAlias: ">30 days",
						AggFunc:    "count_distinct",
						Filter:     []Filter{{Field: "$age", Operator: OperatorMore, Values: []string{"30"}}},
						FuncArgs:   []string{"first_found_at"},
					},
				},
				TimeField: "last_found_at",
				GroupBy:   []string{"vulnerability_severity"},
			},
		},
		ColorPalette: chart.ChecksColorPaletteName,
	},

It uses WidgetDensityGrid and contains a single query with the required query named density. The query doesn't contain any filters because all of them should be added dynamically (on dashboard/report filters configuration). All other filters are applied as post-filters on each field separately.

In the example above we specify a field aliased as $age for which we calculate date difference. Later we use variable $age inside post-filters. Each field has a post-filter based on $age and each of this fields with post-filter uses count_distinct aggregation function.