Metric Plot

Compare metrics on a timeseries plot

Parameters

Name	Type	Description	Is Optional
metrics	comparison_list	List of input metrics/calculations to plot
filters	filter_list	Filter logic on one or more columns. Can choose between a simple comparison filter or advanced filter using free text.	True
group_by_dimensions	dimension_list	Categorical column(s) by which to pivot the calculated metrics. Including this argument will generate a new metric calculation for each distinct value in the group by column. If this column has more than 20 distinct values, the plot will not generate.	True
timeseries_options	timeseries_options	(Required if 'x_axis' is a date/datetime type) A dictionary containing the start and end dates as well as the time grain which will be used to create the datespine for the x_axis. Time grain options are ('day', 'week', 'month', 'year', 'quarter', and 'all') Example: { "start_date": "2021-12-01", "end_date": "2022-07-01", "time_grain": "day" }

Example

ds = rasgo.get.dataset(id)

ds2 = ds.metric_plot(
  metrics=[
    {
      "name": "Total_Sales"
      "type": "SUM",
      "source_table": "RASGO.PUBLIC.SALES",
      "target_expression": "TOTALSALES",
      "time_dimension": "BILLING_DATE",
      "time_grains": ["WEEK","MONTH","QUARTER","YEAR"],
      "secondary_calculation": {
        "type": "period_over_period",
        "comparison_strategy": "ratio",
        "interval": 7
      }
    }
  ],
  group_by_dimensions=["BUSINESS_SEGMENT"],
  timeseries_options={
    "start_date": "2021-12-01",
    "end_date": "2022-07-01",
    "time_grain": "day"
  },
  filters=[
    {
      "column_name": "BILLING_REGION",
      "operator": "="
      "comparison_value": "SOUTHWEST",
    }
  ]
)
ds2.preview()

Source Code

RasgoTransforms/metric_plot.sql at main · rasgointelligence/RasgoTransformsGitHub