Hi All.... I am trying to build a dashboard in Einstein Analytics. My dashboard has 2 datasets:
Targets and Actuals.
Widget 1 is to show Target.
Widget 2 is to show Actuals.
Widget 3 is to show Target x Actuals, so I had to use 2 datasets in the same widget.
Einstein should filter data of all dashboard when I click on any widgets, however
when I click in the 1st or 2rd widget I got a error in the 3rd widget (which is the widget with 2 datasets).
The error is described below:
"This widget can't be displayed because there is a problem with its source query:
Syntax Error at position [line 1: column 241] after token JUN :: ') == P12 JUN 2021,Non Food
"
If I click again on the widget ( must be in the same position ), the issue disappear from screen.
Does someone had already experienced this issue?
I can not delivered a dashboard for client with this problem...
Much appreciate any insights...
Thanks.
Have you connected the data sources in the dashboard on all of the common fields? Without connections I think you are probably filtering out all of the second dataset when you click on the first. Can you show your SAQL for the widget with the join as well? The join type may be causing the issue.
