Using Rankdesc to create a custom Column

[Flo_Rod]

Hi, 
I am a sisense newbie. I am trying to create a custom column in the data model to rank latest week and other weeks from latest to oldest. I am using a live model connected to a snowflake database.  The data is such that once a week its refreshed and customer purchases for the range of that week are entered against a single day. Whenever I try to save this formula, I am getting an error. Can someone help me fix this formula please.

Formula: RANKDESC("purchase date")

Error: Parsing failed: SQL compilation error: Unknown function RANKDESC

[DRay · Accepted solution]

Hi @Flo_Rod,

Thank you. Queries against a Live Data Source use the data source syntax, not the Sisense syntax. Here is the Snowflake documentation for RANK. Can you take a look at that and let us know if it helps?

Thank you.

[DRay]

Hi @Flo_Rod.

Can you tell us what the error message says? That should help us figure out what the issue is.

[Flo_Rod]

Formula: RANKDESC("purchase date")

Error: Parsing failed: SQL compilation error: Unknown function RANKDESC

[DRay · Accepted solution]

Hi @Flo_Rod,

Thank you. Queries against a Live Data Source use the data source syntax, not the Sisense syntax. Here is the Snowflake documentation for RANK. Can you take a look at that and let us know if it helps?

Thank you.

[Flo_Rod · Accepted solution]

Thank you @DRay I ended up changing the SQL query  in the data model. The function I used was:
DENSE_RANK() OVER (ORDER BY PURCHASE_DATE DESC) AS CC_PURCHASE_DATE_RANK
 This created the custom column I required.