Raw Records Query Mode

Raw Records Query Mode

OVERVIEW

Raw Records query mode in Pluto Insights is a setting that allows you to display your data in its most detailed form, without any aggregation or summary. Each row in your chart corresponds directly to a row in your dataset.

HOW TO SETUP THE RAW RECORDS QUERY MODE

Let's use course enrollments as an example. Suppose you have a dataset that records individual course enrollments at your company, with columns for "Learner Name", "Course Name", "Enrollment Date", and "Progress".

If you wanted to create a table that lists all enrollments for a particular course, you could use Raw Records query mode. In this mode, you could filter by the "Course Name" to display only the rows related to that course.

The resulting table would show each individual enrollment for that course, with a row for each learner, showing their name, the date they enrolled, and their progress.



Raw Records query mode is useful when you need to see the individual records in your dataset, rather than a summary or aggregate view. It's ideal for detailed examinations of data and for creating tables that list individual records.

    • Related Articles

    • Aggregate Query Mode

      OVERVIEW Aggregate query mode in Pluto Insights is a setting that determines how your data is processed and displayed in your charts. In Aggregate query mode, the data is grouped based on the selected columns and then mathematical or statistical ...

    • Group By

      OVERVEW The "Group By" feature in Pluto Insights is a function that categorizes data into groups based on selected columns in your dataset. It's often used in conjunction with aggregate functions (like SUM, AVG, COUNT, etc.) to provide summarized ...

    • How to create a Bar chart

      Overview A Bar Chart compares metrics from different categories using bars. Bar lengths are used to indicate the magnitude of each value and colour is used to differentiate groups. Creating a Bar Chart Step 1: Select the "Charts" tab in the top bar, ...

    • How to create a Pie chart

      OVERVIEW A pie chart is a circular graphical representation used to display data as a proportional distribution of categories. The chart resembles a pie, with each category represented as a slice, where the size of each slice corresponds to the ...

    • How to create a Time-Series Area chart

      OVERVIEW A time-series area chart is a type of data visualization that represents the changes in values over time. It is similar to a line chart, but with the area between the line and the time axis filled with color or shading. The area between the ...