0

Cant Grasp datasources and select function

Mohammad Al-Hashim

February 26, 2021 09:01

None

Follow

Hi,

I appreciate your support, I have spent many days in this problem, something escape my understanding.

My problem is very typical, I have number of "DEALS" and "ADD_DATE". I just want to filter out DEALS that were ADDED this quarter. So I tried doing the following function:

I have tried the following reference recommending SELECT function https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions#BETWEEN

 

But the problem that data is not correct, its not corresponding to the. first column. 

All I want to accomplish is simply have |DEAD| with |ADDED DATE| Within the last quarter.

 

Appreciate the help

 

 

 

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Meggan King February 26, 2021 15:37

  Hello - 

  This is a great question. I think to understand we would need the support team to look at your Klip, but generally, if SELECT isn't working it means there is a formula or data alignment issue. Do you have the same SELECT and BETWEEN condition in your column for add_date? 

   

  Thanks!