WEBVTT

00:00.733 --> 00:03.900
Welcome to Veeva Connect's
reporting overview for beginners.

00:04.233 --> 00:07.233
In this short video,
we'll take a look at how to use filters

00:07.233 --> 00:08.866
and prompts.

00:10.233 --> 00:12.033
Once you've created a basic report,

00:12.033 --> 00:15.500
you can use filters and prompts
to make your report truly effective.

00:16.100 --> 00:19.200
Instead of seeing all of the records
in your report, type,

00:19.466 --> 00:23.133
you can focus the results down to only
those that are currently relevant to you.

00:24.100 --> 00:26.433
Click edit to bring up our Report Builder,

00:26.433 --> 00:29.433
and we can see that
we can add filters to our report.

00:30.133 --> 00:33.133
Filters may be added to any field

00:33.400 --> 00:36.200
based on your report type.

00:36.200 --> 00:38.366
So we'll go ahead and let's say

00:38.366 --> 00:41.366
we want to filter on the quality event
type.

00:42.300 --> 00:45.233
Quality event type is a dropdown

00:45.233 --> 00:47.700
where we select an object type.

00:47.700 --> 00:49.900
So we are going to see in

00:49.900 --> 00:53.266
equals is not equal to is blank
or is not black.

00:53.533 --> 00:56.566
And depending on the data
type of any of the fields you select.

00:57.000 --> 01:01.066
For example a date or a text or a number,
you'll see different operators.

01:01.600 --> 01:04.600
You may define as many filters
as you like in a report.

01:04.933 --> 01:08.533
We'll go ahead and we'll add
one more for that.

01:08.533 --> 01:12.066
Create a date
so we can work against a time period.

01:13.700 --> 01:14.400
As you can see we

01:14.400 --> 01:17.400
have quite a few options here.

01:17.433 --> 01:20.300
I'm going to say is before

01:20.300 --> 01:23.100
it's going to ask me for a date.

01:23.100 --> 01:27.333
But prompts are special filters
that are determined at run time and allow

01:27.333 --> 01:31.433
the user to who is running the report
to determine the value to filter by.

01:31.966 --> 01:35.166
This makes your report more flexible
because, as an example,

01:35.533 --> 01:39.000
a single report can be used to focus
on many different time periods.

01:39.366 --> 01:43.633
So we'll select prompt and we will not
have to define it at this time.

01:44.633 --> 01:47.766
I'm going to select deviation here.

01:48.033 --> 01:50.533
So we're only looking for deviations.

01:50.533 --> 01:54.433
And then we'll get to decide that time
period that we want to run it against.

01:55.233 --> 01:57.666
Before we run this report I'm going to add

01:57.666 --> 02:01.166
one more field here
the quality event type.

02:01.333 --> 02:03.733
Just so we can confirm
that our filter is working.

02:05.766 --> 02:07.833
I'm going to hit okay.

02:07.833 --> 02:10.800
And we're going to run this report.

02:10.800 --> 02:11.966
Notice we're running it.

02:11.966 --> 02:14.966
So it's in preview.
We're not saving it yet.

02:15.000 --> 02:19.700
And I want to see any of the deviations
created before March.

02:19.700 --> 02:22.700
First of this year.

02:22.966 --> 02:23.700
It's running.

02:23.700 --> 02:27.533
And we've taken our 71 results down to 12

02:27.600 --> 02:32.066
by only showing the deviations
created before March 1st,

02:33.000 --> 02:37.066
because reports that return more records
take longer to run for users

02:37.066 --> 02:41.733
with access to hundreds or thousands,
even millions of documents or records.

02:42.100 --> 02:44.866
Defining filters can help
ensure the report provides

02:44.866 --> 02:47.866
a good user experience.

02:49.433 --> 02:51.066
Thank you for joining us for our look

02:51.066 --> 02:54.066
at how to use filters and prompts
with your reports.

02:54.133 --> 02:56.900
Be sure to check out our next Beginner
Series video,

02:56.900 --> 03:01.333
where we'll explore how to perform
calculations across rows using groups.
