Unknown symbol in Insight

[Jeremy_Likezero]

I have populated an insight with a dimension in the “Categories” field. I have a “Unique Values” calculation on the category, but when I try to use it in a “Block If” I get a “There are errors in your narrative” message in the preview. If I put the unique count or the category in the narrative on its own, I get an “Unknown Symbol” error (see image).

That GUID does exist, however, in the exported json for the analysis:

Any idea what’s going on here?

[Jeremy_Likezero]

I should add, I am trying to capture the “No data” message when there are no results.

This is discussed here:

Can I show an error message on dashboard when user enters wrong data in textfield filter in the Controls?

It is possible to use insight visual to display some text if query result contains no data. The easiest way to do it is click “Add Insight” in the top left corner select Unique Values from the list of insights and click “Select” to close the dialog. add a field to the “Category” field well select “Customize narrative” option on the visual to display your own message and change the entire expression to something like the image below [Screen Shot 2022-03-21 at 3.53.50 PM]

And here:

Display a custom message on Insights when no data is returned

Insights are a great way to show meaningful data on your dashboard. You have the choice of including suggested insights that QuickSight provides, or you can create custom insights with your choice of computations. The example below shows a period over period insight with filters applied for data range and Product. [image(13)] You might encounter situations where an insight might display a ‘No results’ message when there was no data found, usually due to a filter selection that resulted in n…

[Jeremy_Likezero]

[Jeremy_Likezero]

I have a workaround for this. The recordset needs to have dummy records which only exist in the dataset for the purpose of enabling counters. The dummy records can be identified by having a NULL Id field. The main widget which is displaying the data has a visual-only filter to exclude the NULLs. This leaves the NULLs visible in the Insight widget IF … you crossjoin all your filter box options as dummy NULL records. You have to be intelligent with how you create calculated fields in the dataset which can interpret what is going on. I created these as countif(1,…) and then they can be added to the Insight as custom calculations to be turned into TotalAggregation fields in the Insight. Confusing! Would be much easier if the Insight allowed a message when there is no data!