Using a pie chart to display the conditional breakdown of data that has been filtered (urgent)

[shirleyc40]

Hi!

I have the following table: 

And I have a calendar to pick a date range. I'm trying to count how many of the quotes that started in the range were taken within the date range. So for example, right now I have 6/4-6/7 selected. There are a total of 10 quotes that started in that date range. Of those 10, only 1 was taken within 6/4-6/7. So I want the pie chart to show 1 taken and 9 not taken. Is that possible? Or do I have to change something when I load this table? This is what I have in my load script:

Temp:
LOAD
    eventId,
    TimeStamp(TimeStamp#(eventDateTime, 'YYYY-MM-DD hh:mm:ss.fff')) as eventDateTime,
    Date(floor(TimeStamp#(eventDateTime, 'YYYY-MM-DD hh:mm:ss.fff'))) as eventDate,
    eventName,
    eventType,
    systemId,
    environment,
    "userId",
    userFirstName,
    userLastName,
    producerTransactionId,
    triggerDescription,
    quoteNumber,
    policyNumber,
    ratingReferenceNumber,
    agentNumber,
    applicationSignedState,
    licensingCheckResult,
    esignatureStatus,
    applicaitonDecision,
    if (applicaitonDecision = 'Approved', 1, 0) as Decision
FROM [lib://DataFiles/Mock Data (2).xlsx]
(ooxml, embedded labels, table is Sheet1);


A:
LOAD 
Date(Min(eventDate)) as StartTime,
Date(Max(eventDate)) as LatestTime,
quoteNumber,
if (Sum(Decision) = 1, 'Taken', 'Not Taken') as AppDecison
Resident Temp Group By quoteNumber;

Thank you! I'm trying my best to learn and use Qlik