Introducing AutoQL’s Newest Feature: Adding Additional Columns to Data Query Results

In the world of data analysis, it’s not uncommon to find yourself missing a crucial piece of information needed for your insights. That’s where the ability to add an additional column of data to your existing query results comes in handy. With Chata.ai, this process becomes seamless, allowing you to enhance your analysis and visualization effortlessly.

Types of Additional Columns Offered

AutoQL by Chata.ai offers a range of column types that can be added to your data response, and each has its unique benefits. Here are some examples of when each column type might be useful:

1. Calculation Column
   A calculation column allows you to add additional calculations based on existing data using a formula (averages, minimum/maximum values, standard deviation, etc). It provides a way to compare the data and extract more insights from it.

2. Value Column
   Adding a value column makes it easier to sort, filter, and analyze the data and can be helpful in organizing and referencing data. A value column is particularly useful when you need to keep track of different items, such as products, customers, or orders.

3. Date/Time Column
   The date/time column allows for easy filtering and aggregation of data based on specific time frames. You can zoom in or out of periods of interest, aggregate data by days, weeks, months, or years to gain insights at different granularities.

Leveraging the Additional Column in AutoQL by Chata.ai

Adding a column in AutoQL is a straightforward process, tailored to accommodate various user workflows:

From Data Messenger:

1. Open the AutoQL Webapp.
2. Access Data Messenger.
3. Input your query with a group-by for analysis.
4. Click the plus icon located at the top right corner of the table (note: adding a column doesn’t work in the pivot table view).
5. Select the desired column to add.
6. Fine-tune the visual display as needed.

From Dashboards:

1. Open the AutoQL Webapp.
2. Navigate to the Dashboard you’d like to edit.
3. Edit an existing tile or add a new one, ensuring the query includes a group-by.
4. Click the plus icon at the top right corner of the table (note: adding a column doesn’t work in the pivot table view).
5. Choose the column to add from the options provided.
6. Adjust the visual representation if necessary.

When using AutoQL, it’s important to keep in mind that there are some limitations to adding columns to your data. While the platform does offer the ability to add columns, there is a limit to the number of columns that can be added and the types of columns that are available.

It’s also important to note that adding too many columns can cause performance issues within AutoQL. To ensure that AutoQL continues to function smoothly, it’s best to only add the columns that are necessary for your analysis and to avoid adding excess columns whenever possible.

With these simple steps, you can now seamlessly integrate additional columns into your query responses, unlocking new dimensions of data analysis and visualization. Whether you’re crunching numbers for insights or crafting compelling visualizations, Chata.ai empowers you to harness the full potential of your data with ease.

Interested to learn more? Book a demo with our team →