Skip to main content
Ravi Deshmukh 님이 #CRM Analytics에 질문했습니다

I have a table widget which has a date field. This field when clicked is sorting by year instead of a date. I would like to see rows that have a recent date assigned. I tried editing SAQL query -> 

q = order q by Close Date asc;  but its throwing up an error like this 

답변 3개
  1. 2022년 1월 11일 오전 12:27

    Check if it works in a syntax like this 

    result = order result by ('Close_Date_Year~~~Close_Date_Month~~~Close_Date_Day' asc);

    If there is a space in the API name, i think it is not going to work.

    Check the details in fields panel.

    Check if it works in a syntax like this result = order result by ('Close_Date_Year~~~Close_Date_Month~~~Close_Date_Day' asc);If there is a space in the API name, i think it is not going to work.

0/9000