- Log in to post comments
User bio
I am on the InterSystems Support team and I primarily focus on Analytics and SQL. I enjoy working on projects for the community, see my GitHub
Member since Dec 11, 2015
Posts:
Replies:
It turns out this was a bug with parallel processing where the negative numbers in the data were more negative than the null marker caused data to be skipped. Development is fixing this
- Log in to post comments
Hi Virat,
In %OnGetFilterMembers, you will have access to pFilter, which will contain the name of your filter, "SubjectName" in this example. You will also have access to pMembers, which is an array of members that the SearchBox dropdown will use in the UI. By default, this will contain the results from sql="SELECT DISTINCT SubjectName FROM BI.Invoice". You will also have access to pFilterValues, which contains an array of already selected values. In your case, "Virat and Big Show". You would then need to use this information to remove values from the pMembers array to reduce the available members.
By default, IRIS BI does this "member filtering" for you. The use of KPIs is very customized, so it requires some additional custom logic to allow this behavior
- Log in to post comments
Open Exchange applications:
Certifications & Credly badges:
Followers:
Following:
Peter has not followed anybody yet.
I am not seeing the source data here, can you share that again?
Also, what does your build output show? You only have a count of 5, which means you either only have 5 rows in your table OR the rest are getting errors. If they are getting errors, we should be able to learn more about what is wrong with it