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).
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!