TD_PLOT Function Examples | Teradata Vantage - TD_PLOT Examples - Teradata Vantage

TD_PLOT Input Table OCEAN_BUOYS

Example: TD_PLOT Call for Line Chart

This example specifies the chart to be a 1024x768 PNG. The plot is a line chart with a title named XY Plot. There is a single data series which is plotted using a red dashed line.

EXECUTE FUNCTION
TD_PLOT(
  SERIES_SPEC(
    TABLE_NAME(OCEAN_BUOYS),
    ROW_AXIS(SEQUENCE(SALINITY)),
    SERIES_ID(BuoyID),
    PAYLOAD (
      FIELDS(TEMPERATURE),
      CONTENT(REAL)
    )
  )
  WHERE BuoyID = 33,
  FUNC_PARAMS(
    TITLE('XY Plot'),
    PLOTS[(
      TYPE('line'),
      FORMAT('r--')
    )],
    WIDTH(1024),
    HEIGHT(768)
  )
);

TD_PLOT Output for Line Plot

Example: TD_PLOT Call Using ID_SEQUENCE

This example generates the same plot as the previous example. It uses ID_SEQUENCE instead of WHERE clause to specify the data series.

EXECUTE FUNCTION
TD_PLOT(
  SERIES_SPEC(
    TABLE_NAME(OCEAN_BUOYS),
    ROW_AXIS(SEQUENCE(SALINITY)),
    SERIES_ID(BuoyID),
    ID_SEQUENCE('[{"BuoyID":33}]'),
    PAYLOAD (
      FIELDS(TEMPERATURE),
      CONTENT(REAL)
    )
  ),
  FUNC_PARAMS(
    TITLE('XY Plot'),
    PLOTS[(
      TYPE('line'),
      FORMAT('r--')
    )],
    WIDTH(1024),
    HEIGHT(768)
  )
);

TD_PLOT Output for ID_SEQUENCE

Example: TD_PLOT Call for Wiggle Chart

EXECUTE FUNCTION
TD_PLOT(
   MATRIX_SPEC
   (
      TABLE_NAME(waveletTable),
      ROW_AXIS(SEQUENCE(x)),
      COLUMN_AXIS(SEQUENCE(y)),
      MATRIX_ID(ID),
      PAYLOAD
      (
         FIELDS(c),
         CONTENT(REAL)
      )
   ),
   FUNC_PARAMS
   (
      PLOTS[(
      TYPE('wiggle')
      )],
     IMAGE('png')
   )
);

TD_PLOT Output for Wiggle Chart

Example: TD_PLOT Call for Composite Chart

Composite charts position the graphs top left, then down, then top right, and then down.

EXECUTE FUNCTION
TD_Plot
(
    SERIES_SPEC
    (
        TABLE_NAME(TimeSeriesDataSetsD4),
        ROW_AXIS(SEQUENCE(SeqNo)),
        SERIES_ID(DataSetID),
        PAYLOAD
        (
           FIELDS(Magnitude),
           CONTENT(REAL)
        )
    ) WHERE DataSetID=552,
    SERIES_SPEC
    (
        TABLE_NAME(ACF_RES_552),
        ROW_AXIS(SEQUENCE(ROW_I)),
        SERIES_ID(DataSetID),
        PAYLOAD (FIELDS(Magnitude, CONF_OFF_Magnitude),CONTENT(MULTIVAR_REAL) )
    ) WHERE DataSetID=552,
    SERIES_SPEC
    (
        TABLE_NAME(PACF_RES_552),
        ROW_AXIS(SEQUENCE(ROW_I)),
        SERIES_ID(DataSetID),
        PAYLOAD (FIELDS(Magnitude, CONF_OFF_Magnitude),CONTENT(MULTIVAR_REAL) )
    ) WHERE DataSetID=552,
    SERIES_SPEC
    (
        TABLE_NAME(PWRSPEC_RES),
        ROW_AXIS(SEQUENCE(ROW_I)),
        SERIES_ID(DataSetID),
        PAYLOAD
        (
           FIELDS(SPECTRAL_DENSITY_Magnitude),
           CONTENT(REAL)
        )
    )WHERE DataSetID=552,
    FUNC_PARAMS
    (
        LAYOUT(2,2),
        WIDTH(1920),
        HEIGHT(1080),
        TITLE('SAVINGS RATES STATIONARITY PANEL'),
        PLOTS[
            (
                ID(1),
                CELL(1,1),
                TITLE ('SAVINGS RATES DATASET TIME SERIES'),
                GRID(FORMAT('-')),
                TYPE('line'),
                MARKER('o'),
                LEGEND('best'),
                XLABEL('X SeqNo'),
                YLABEL('Y Magnitude')
            ),
            (   ID(2),
                CELL(1,2),
                TITLE ('SAVINGS RATES DATASET ACF RESULT SERIES'),
                TYPE('corr')
               ,XLABEL('X LAG')
               ,YLABEL('Y Magnitude')
            ),
            (   ID(3),
                CELL(2,1),
                TITLE ('SAVINGS RATES DATASET PACF SERIES'),
                TYPE('corr')
               ,XLABEL('X LAG')
               ,YLABEL('Y Magnitude')
            ),
            (
                ID(4),
                CELL(2,2),
                TYPE('line')
               ,MARKER('o')
               ,XLABEL('X ROW_I in W K_RADIANS')
              ,YLABEL('Y SPECTRAL DENSITY MAGNITUDE')
              ,TITLE ('SAVINGS RATES DATASET POWER SPECTRUM RESULTS')
              ,LEGEND('best')
              ,GRID(FORMAT('-'))
            )
        ]
    )
);

TD_PLOT Output for Composite Chart

Example: TD_PLOT Call for Geometry Plot

CREATE TABLE shapeTable1 (
    id      INTEGER,
    x       FLOAT,
    HEAT    FLOAT,
    SHAPE   ST_GEOMETRY(64000)
)
NO PRIMARY INDEX;

INSERT INTO shapeTable1 VALUES (1, 1.0, 1.0, 'POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))');
INSERT INTO shapeTable1 VALUES (2, 2.0, 2.0, 'POLYGON((2 2, 2 4, 4 4, 4 2, 2 2),(2.5 2.5, 2.5 3.5, 3.5 3.5, 3.5 2.5, 2.5 2.5))');
INSERT INTO shapeTable1 VALUES (3, 3.0, 3.0, 'POLYGON((10 1, 4 19.8, 19 7.8, 1 7.8, 16 19.8, 10 1))');

EXECUTE FUNCTION
TD_Plot
(
    SERIES_SPEC
    (
        TABLE_NAME (shapeTable1),
        SERIES_ID (id),
        ROW_AXIS (SEQUENCE (x)),
        PAYLOAD
        (
            FIELDS (HEAT, SHAPE),
            CONTENT (MULTIVAR_ANYTYPE)
        )
    ),
    FUNC_PARAMS
    (
        PLOTS [(
            TYPE ('geometry')
        )]
    )
);

TD_PLOT Output for Geometry Plot

ROW_AXIS values are not considered. It uses the SERIES_ID order to calculate the border colour and the HEAT value to calculate the relative colour intensity.