User Profile

Flo_Rod

Cloud Apps

Joined 2 years ago

3 Posts3 Likes1 Solution

View All Badges

User Widgets

Contributions

Re: Using Rankdesc to create a custom Column
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.
03-12-2024 Place Build Analytics
2.1KViews
1like
0Comments
Re: Using Rankdesc to create a custom Column
Formula: RANKDESC("purchase date") Error: Parsing failed: SQL compilation error: Unknown function RANKDESC
03-12-2024 Place Build Analytics
2KViews
1like
2Comments
Using Rankdesc to create a custom Column
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
Solved
03-12-2024 Place Build Analytics
data models
2.1KViews
1like
4Comments