Geckoboard Developer Community

Feature Request: Pipedrive Deals - add more filters


#1

We’d love to have more filter possibilities for Pipedrive deals connector. ATM we’re running a query and push the results into a dataset. Our query looks like this:

SELECT count(*) AS KPI
FROM pipedrive_deals
WHERE pipeline_id IN (96, 107, 124)
AND (creator_user_id = 2960880 OR marketing_channel LIKE '%330%')
AND date_trunc('month', add_time) = date_trunc('month', now())

So it would be nice to be able to filter on creator_user_id and add_time directly in the Pipedrive deals connector.
marketing_channel is a custom field, could that be filtered on too? :blush: