1

I have created a Wave Report which I need to sort by Number field. I am not able to add Formula(Number) in Group by column even with using SAQL.

I have already tried the workaround to change Formula(Number) to Formula(Text) but Salesforce sort text field as alphanumeric sort and not natural sort so it doesn't work for me.

Any help would be highly appreciated.

Cheers

0

The guide clearly mentions to use order by for sorting and not grouping .

https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_order.htm

enter image description here

You will need to use order by clause in your saql

  • Hi Mohith, Yes, you can sort by text and date field using order by clause but when I try adding number field, its giving me exception. – Wahib Idris Sep 11 '17 at 10:30
  • I am getting Unknown IDTOKEN: exception when I try to add the number field in order by clause. – Wahib Idris Sep 11 '17 at 10:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.