# Domo - Two Time Periods on One Card

1. Problem Statement:

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

The funnel data comes from two main sources:

• SQL

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

• 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

Solve this problem.

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

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

## freelancer 1 คน กำลังเสนอราคาเฉลี่ยที่ \$170 สำหรับงานนี้

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