[SalesForce] Faceting Not Working Within Dataset – Einstein Analytics

I am editing a dashboard in Einstein Analytics. It contained 5 charts, all from the same datasource, and they all faceted between one another when selections were made. I was asked to change the top chart– a line graph showing opportunity creation by week– and make it a stacked bar chart showing the same thing, but broken out by opportunity creator. Now that chart will no longer broadcast its selections to the other charts. If I click on one of the bars, it gets highlighted but nothing else happens. Everything else still works fine. If I make a selection in chart 2, every other chart (including the one I edited) gets filtered by the selection. Everything is from the same datasource, and everything has send/receive facets turned on. Does anyone know what might cause this?

Thanks!

Best Answer

If you have done any changes in SAQL means if you have added any field or removed then check that the field names are in the same order as in group statement and foreach statement. if not put them in same order and then update your step now faceting may work

Related Solutions

[SalesForce] How to bucket field values in Einstein analytics

Basically you have 2 options:

Bucket in a dataflow or recipe
Bucket in the dashboard. For that you have to write custom SAQL. In your query insert a line containing "case when" like the following

q = foreach q generate case when orderCountry in ["AUS", "USA", "GBR"]
                            then "Yes"
                            else "No"
                       end as Bucket1,
                       case when orderCountry in ["USA", "GBR", "IND", "KEN"]
                            then "Yes"
                            else "No"
                       end as Bucket2,
                       case when orderCountry in ["KEN", "AUS", "IND"]
                            then "Yes"
                            else "No"
                       end as Bucket3;

Then create subqueries to count

result1 = group q by Bucket1;
result1 = foreach result1 generate Bucket1, count() as countBucket1;

result2 = group q by Bucket2;
result2 = foreach result2 generate Bucket2, count() as countBucket2;

result3 = group q by Bucket3;
result3 = foreach result3 generate Bucket3, count() as countBucket3;

And finally union or cogroup the suqueries back together, depending on what you want to do with these numbers.

Hope that helps!

Related Topic