Questions tagged [saql]

SAQL - Salesforce Analytical Query Language

Filter by
Sorted by
Tagged with
1
vote
2answers
2k views

SAQL Using Current year and doing calculations with dates in a Formula Condition

I want to do calculations with dates and use 'current year' in a formula condition. When I tried to manipulate dates in a formula I always receive an error of incompatibles types; NUMBER AND DATE. ...
0
votes
4answers
3k views

How to convert decimals to a percentage in Wave Saql query result

I want to show the reuslt with the percentage, what should I do?
1
vote
2answers
837 views

How to do a simple math on aggregate values from different streams in SAQL?

This should be some basic stuff but lack of good documentation on SAQL is making it hard to figure out. I just want to do a simple math like ths- Avg. Sale Price = Total Sale Price/Qty The filters ...
1
vote
1answer
3k views

In Wave/Einstein analytics, is it possible to combine query results from 2 different datasets into the same visualization?

I am creating charts/tables on a Wave Dashboard using a small number of datasets that I've created using dataflows and recipes. What I want to do now is to query (i.e., somehow get data) from two of ...
1
vote
1answer
707 views

Date format in SAQL

I have a requirement in Wave Analytics where I need to fetch records from Previous year when current year is completed. I have a field named Processing Year. It now fetches 2017 records which we have ...