Skip to content
wolfgangherfurtner

wolfgangherfurtner

People Gotta See More

Primary Menu wolfgangherfurtner

wolfgangherfurtner

  • News Business
  • traffic finance
  • business markets
  • finance & accounting
  • Finance & Oportunity
  • business ideas
  • About Us
    • Advertise Here
    • Contact Us
    • Privacy Policy
    • Sitemap
  • Home
  • Creating a loss triangle | Domo
  • Finance & Oportunity

Creating a loss triangle | Domo

Thelma D. Griggs 04/06/2022 4:51 AM

Table of Contents

Toggle
  • Problem
  • Solution
  • Demo

[ad_1]




 / Creating a loss triangle

















Problem

A critical need for any insurance company is track claim losses over time by displaying them in what are called “loss triangles.” Typically, this is a very manual process looking that involves looking at the financial transactions over the last year and when the claim occurred and updating an Excel spreadsheet. 

Solution

By leveraging Magic ETL and using the pivot table card, I have been able to automate this process and allow our Finance team to view updated triangles any time they want. I enhanced it even further by using Form Builder, which allows the user to select a specific evaluation date in case they don’t want the most recent date, but want to look at as of a certain historical date. This saves our company countless hours each month and also improves accuracy by implementing this solution.

Demo

To produce the loss triangles, I leverage the group by tile and the rank and window tiles to create running totals. This allows me to show losses for each year of a claim. I then use the pivot table card and place the loss year in the row and the transaction year (or months of development) in the columns and the amount in the value field. This will result in the information being displayed in the shape of a triangle.













[ad_2]

Source link

Post Navigation

Previous Why modern businesses have made data apps a key focus
Next Why Your Small Business Should Be Doing Video Marketing

More Stories

Top Quality Forex Education Is Essential to Success
  • Finance & Oportunity

Top Quality Forex Education Is Essential to Success

Thelma D. Griggs 28/07/2024 7:26 PM 0
Analysis of Risks to a Project Developer in a Term Sheet Or a Power Purchase Agreement (PPA)
  • Finance & Oportunity

Analysis of Risks to a Project Developer in a Term Sheet Or a Power Purchase Agreement (PPA)

Thelma D. Griggs 27/07/2024 7:51 AM 0
Books on Business, Law and Finance
  • Finance & Oportunity

Books on Business, Law and Finance

Thelma D. Griggs 24/07/2024 4:46 AM 0
July 2025
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  
« Mar    

Archives

  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • November 2021
  • October 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • November 2018
  • December 2016

Categories

  • Business
  • business ideas
  • business markets
  • Entertainment
  • finance & accounting
  • Finance & Oportunity
  • News Business
  • Property
  • Real Estate
  • traffic finance

Recent Posts

  • Fast Relief: Understanding Payday Loan Singapore Options
  • 6 Challenges to Achieving Financial Sustainability
  • Mayajaal Movie Review: A Thrilling Ride Through Mystery and Deception
  • Investment Insights: Why EBITDA Matters in UK Financial Analysis
  • 5 Ways to Track and Analyze Your Stock Portfolio Online

Fiverr

Fiverr Logo

Tags

5e Business Profit Ahron Levy Columbia Business School Att Business Login Business Consultant Certification Austin Business Insurance Cover Coronavirus Business Letter With Logo Example Business Located Easy Location Business Platform Stocks Business Positions Seattle Business Regulation Legal Services Daystarr For Business Dimagi Business Development Toolkit Do Business Schools Accept Entreprenuers Enironmentall Friendly Business Ideas Eric Early Republican Business Owner Essec Business School Dean Essential Business To Remain Open Example Small Business Fall Winter Business Hours Template Fdot Woman Owned Business Certification First Business Women United States First Com Business Fixing A Damaged Reputation Business Florida Business Enforcement Free Small Business Communication Tool Law School Business Entity Outlines Mapping A Business Location Medical Business Trends Economics Mix Business And Personal Money Mlm Nit Small Business Legally New Business Agency Sales Questions Patricia Saiki Women'S Business 1990 Safety Business Proposal Sample Business Plan Entrepreneur School Business Administration Positions S Corp Business Deductions Search Tx Business Llc Sentextsolutions Business Cards Signs For Business On Roads Skype For Business Recording Capacity Small Business Forums .Net Small Business Insurancr Tech Monkey Business Ttu Business Cards Template Turbotax Business Nys Forms
sysmodo
deencast

You may have missed

Fast Relief: Understanding Payday Loan Singapore Options
  • business ideas

Fast Relief: Understanding Payday Loan Singapore Options

Thelma D. Griggs 08/03/2025 12:30 AM
6 Challenges to Achieving Financial Sustainability
  • business ideas

6 Challenges to Achieving Financial Sustainability

Thelma D. Griggs 26/02/2025 12:58 AM
Mayajaal Movie Review: A Thrilling Ride Through Mystery and Deception
  • Entertainment

Mayajaal Movie Review: A Thrilling Ride Through Mystery and Deception

Thelma D. Griggs 21/02/2025 9:04 AM
Investment Insights: Why EBITDA Matters in UK Financial Analysis
  • business ideas

Investment Insights: Why EBITDA Matters in UK Financial Analysis

Thelma D. Griggs 03/02/2025 1:15 AM
5 Ways to Track and Analyze Your Stock Portfolio Online
  • business ideas

5 Ways to Track and Analyze Your Stock Portfolio Online

Thelma D. Griggs 17/01/2025 6:14 AM
wolfgangherfurtner.com | CoverNews by AF themes.

WhatsApp us