ปิด

Domo - Two Time Periods on One Card

1. Problem Statement:

I’m seeking to replicate the attached funnel within Domo.

[login to view URL]

The funnel data comes from two main sources:

• SQL

• Google Analytics

2. What I’ve done so far:

• I’ve extracted the data within Domo

• Written beast calculations to extract the data as required in a sandbox

3. Specific Challenge

• I’m seeking to provide percentages/ratios of specific fields

• The problem with comparing this data is that the date range field for each field is different for each field

3.1 There are a number of different dates that are available for each record

[login to view URL]

• User Added on Time

• Valuation Added on Time

• Appointment Status Change Time

• Valuation Status Change Time

• Appointment Date

3.2 To illustrate the issue, let’s assume the following for the month of:

• 100 Valuations (January), 150 Valuations (February)

• 40 Appointments (January), 80 Appointments (February)

• 20 Purchases (January), 40 Purchases (February)

So for January, Purchases/Valuations should be 20% and Purchases/Purchases should be 50% in this example, but I can’t select two different date fields in Domo to create these ratios.

3.3 Let’s illustrate this issue with two examples.

• Adam created a valuation on the 29th January, his appointment is for the 2nd February and his vehicle was purchased on the 5th February.

• Ben created a valuation on the 1st January and his appointment was for the 5th January and his vehicle was purchased on the 10th January.

• Cara created a valuation on the 29th January, her appointment was for the 31st but the buyer updated the appointment on the 1st February to report a purchase

When we analyse this on a monthly view, Adam’s and Cara’s data falls into difficulty.

If I select for the card Valuation_Added_On_Time the month of January

• Valuations

o Come from Valuation Added On Time

• Appointments

o Come from Appointment Date

• Purchases, No-Shows, Shows

o Come from Appointment change time

The problem comes in when you start looking at percentage performance.

3.4 Problems

• If we select valuation added on date, we end up with an inaccurate purchase count and appointment records

• If we select appointment change date, we end up with an inaccurate valuation count

4. Solution

• To get the right data, I’ve used different cards to select data from the same time range, but off different date range fields.

4.1 Continued Problem

• To get the ratios right (see left/right on the funnel image), I need to select data from two different data range fields on the same card

5. Task

Solve this problem.

ทักษะ: การวิเคราะห์ธุรกิจ, Business Intelligence, SQL, Tableau

ดูเพิ่มเติม : bsuiness card logo T shirt, I like a monist style clean and bold I have attached Logo to be used in any way you want as well as some business card designs t, Home-design-Ideas-Allocate-two-families-in-one-house, https://www.freelancer.com/contest/Home-design-Ideas-Allocate-two-families-in-one-house-860453.html, two words in one tattoos ambigram, part time data entry jobs in t nagar, i m a web devloper programmer and i m woking with sasa software technologies let's start scrolling and learn more about me, hire one card, which of the following error values means that excel doesn t recognize your formula because there is either a misspelled functio, where start looking job for experian e bookkeeper, i need two html page one new and implement redesign for a second, i need two html page - one new and implement redesign for a second, start project 100, significant events different time periods, works art vary greatly across genres time periods, metro looking 100 business minded people, looking 100 paragraphs, mt4 addition time periods, actionscript start slider 100, looking 100 classifieds site

เกี่ยวกับนายจ้าง:
( 230 บทวิจารณ์ ) Swindon, United Kingdom

หมายเลขโปรเจค: #16969657

freelancer 2 คน กำลังเสนอราคาเฉลี่ยที่ $135 สำหรับงานนี้

rutherfordandco

athenaitlimited, please message me, I have all relevant experience for you and my portfolio is guaranteed to impress you. I'm English and based in the United Kingdom. My communication, professionalism and development e เพิ่มเติม

$170 USD ใน 2 วัน
(0 บทวิจารณ์)
0.0
tanmaybala

Hi , I am a full time developer and I have rich 4+ years experiences in Website design , customization and fixing trouble shooting of website and server . My Top Skills is following. ♦ PHP , CSS , JAVA-SCRI เพิ่มเติม

$100 USD ใน 3 วัน
(0 บทวิจารณ์)
0.0