📊Plotting

This tool can be used to plot and visualize data from tables into intuitive charts and empower visual understanding of data.

Introduction

Select Ploting API by entering /Ploting.

This tool can be used to draw any chart of relationships between variables in the data. Here are a few examples

Examples

Plot @1.grossProfit and @1.costOfRevenue, @1.costofGoodsAndServicesSold over time in a parallel bar chart

Plot the aggregation of @1.Total per @1.Nombre over each week in @1.Creado. In each week, plot only top 3 @1.Nombre by @1.Total. Convert number data to numeric. Use a stacked bar chart. Put legend outside on the right side.

To change the default relationship between the width and height, add this to the prompt, where w and h can have any integer values

Set size (w,h)

When there is an error about lack of numeric data, add this to the prompt.

Convert data to numeric

If there is an error message related to date conversion, add to the prompt the following prompt to specify the correct order.

the date order is date, month and year.

Let's certainly choose the result plots in the settings tab.