Pivot Your Way to Reporting Success With Kurve v1.22

News
Product Releases
August 18, 2023

As the summer sun shines brightly above us, so does the excitement of the latest Kurve TRIRIGA release: version 1.22. We are thrilled to introduce 3 new features that will enhance your reporting capabilities and help you analyze your data better. In this blog post, we’ll uncover how these new features empower you to make informed decisions with our intuitive user interface that will surely help steer your organization to success!

Click on a feature below to learn what’s now available in Kurve version 1.22:

  1. Pivot Mode: Transform Kurve report aggregations and summarize data in a new way by pivoting
  2. Descriptions for Graphs and Reports: Gain valuable insights by providing helpful written descriptions of your visualizations for others to read
  3. Grouped Rows Export: Seamlessly carry-over your grouped column names into Excel

1. Pivot Mode

The Pivot Mode functionality offers a seamless way to organize and summarize your data. By selecting row and column labels, you can effortlessly group and categorize your data based on different variables. Whether it's based on task priority, request class, category type, lease classifications or building name, Pivot Mode allows you to transform raw data into a concise and structured pivot table.

How do I use Pivot Mode?

To turn on Pivot Mode:

  • Navigate to a Kurve Report and open the columns section and slide the purple toggle to the right.
  • The report will change to a blank canvas. If you have any groups or aggregations already created, this will carry over to pivot mode.
  • For pivoting to work, you will need to use Row Groups, Values and Column Labels.
  • You can add columns to the Column Labels by dragging into the grey header at the top of the report or directly into the section in the Columns Bar.
  • Once you’re satisfied with your selected Row Groups, Values and Column Labels, make sure you click save!

To turn off Pivot Mode:

  • Switch the pivot toggle to the left. The rest of your report columns will reappear, and you will see the Row Groups and Values carry over. The Column Label section will be removed.

Feel free to refer to also use Kurve's User Guide linked in the app or in the Support Resources Page of this website!

When should I use Pivot Mode?

You should use pivot mode in Kurve whenever you want to analyze, summarize, and present your data in a more interactive and visually appealing manner. Whether you're working on data exploration, cross-tabulation, or report generation, pivot mode in Kurve is a powerful feature that enhances your data analysis capabilities.

Let’s use an example!

Imagine you're managing a project team, and you want to analyze and present the costs associated with different task types based on task priority.

Step 1: Prepare Your Dataset

  • Make sure that you have a TRIRIGA query with relevant information.
  • In this case, you should have a dataset that includes columns for task types, task priorities, and the associated costs.

Step 2: Turn on Pivot Mode

  • Enable pivot mode in Kurve by opening the Columns section and sliding the pivot mode toggle on.

Step 3: Selecting Rows and Columns

  • Choose "Task Type" as your row label. This will form the vertical axis of your pivot table and group data by task types.
  • Select "Task Priority" as your column labels. This will form the horizontal axis and allow you to further categorize data based on these dimensions.

Step 4: Aggregating Data

  • For the values within the pivot table, select "Cost." This will be the data that's summarized and aggregated within the table.
  • Choose the value aggregation option from the hamburger menu and select sum. This determines how the costs will be calculated for each cell in the pivot table.

Step 5: Interacting With the Pivot Table

  • Your pivot table will now display the costs for different task types categorized by request class and task priority.
  • You can rearrange rows and columns by dragging and dropping to change the organization of data.
  • You can apply filters to focus on specific request classes, task priorities, or task types.

You’ve now transformed your data into a structured and insightful presentation. Now that you have your pivot table with the cost data based on task types, request classes and task priorities, you can present this to your team!

With Pivot Mode, Kurve v1.22 empowers users to interactively explore and analyze data. You can easily rearrange rows and columns, apply filters, and summarize data based on different variables. This not only helps your team understand the data, but also helps in making informed decisions and allocating resources effectively.

2. Create Descriptions for Graphs and Reports

While data analysis can be complex, your descriptions should be anything but. Visual representation of data is crucial for understanding patterns and communicating insights effectively. It’s important to use descriptions to guide the reader through the information presented.

What are the benefits of using descriptions when creating data visualizations?

Descriptions provide context to readers to:

  • Highlight key trends & takeaways
  • Offer interpretations of the data's significance

By crafting clear and concise descriptions, you empower your audience to draw meaningful conclusions from the data.

2 Tips for writing the best data visualization descriptions (aka "alt text"):  

  1. Use simple and straightforward language, avoiding jargon or overly technical terms to best communicate what your graph or report entails.
  2. Aim to convey your insights in a manner that is accessible to a broad audience, ensuring that everyone can understand and act upon the information.

3. Exporting Grouped Row Names Into Excel

When it comes to sharing and collaborating on data, Excel remains a popular choice for those who don’t have access to TRIRIGA. Kurve TRIRIGA v1.22 understands this and allows you to export your pivot tables, including the grouped column names, directly to Excel. Retain the structure and organization of your data smoothly, ensuring that valuable insights are preserved and shared effortlessly.

In conclusion, Kurve TRIRIGA v1.22 enhances data visualization, making it easier to communicate findings with clarity and impact.

With pivot mode’s ability to organize, summarize, and visualize data, interactive exploration and analysis become a breeze. You can take your reporting capabilities further and transform your pivot tables into bar charts, line graphs, or pie charts, bringing your data to life. Visualizing data in this manner makes it easier to identify trends, compare categories, and present findings to stakeholders. Moreover, the seamless export of grouped column names to Excel ensures that collaboration and data sharing remain efficient.

If you’d like to see these features in action or have questions, send us an email or schedule a time to chat!

Wishing you all a safe and relaxing summer :)

No Hassle, Only Convenience with Kurve v1.21

Read Next

Other Resources

(v1.25) A Reporting Dive into Optimization
(v1.25) A Reporting Dive into Optimization
News
Product Releases
April 8, 2024
Leaves are Falling, Kurve v1.23 is Calling!
Leaves are Falling, Kurve v1.23 is Calling!
News
Product Releases
October 24, 2023
For more information and general inquiries
Contact Us