Skip to main content
Topics#CRM AnalyticsRavi Deshmukh 的问题
Ravi Deshmukh 提问于 #CRM Analytics
2022年1月10日 17:00

Table widget not sorting by a date format when clicked on Date field

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 

Capture.PNG
3 个回答
  1. Ben Elias
    2022年1月11日 00: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