- 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:
The DC AI Bot is correct here, simply add a new calculated measure - something like "Non-Null Count" and use the ISNULL() MDX function. Instead of using "Count" as your measure, use "Non-Null Count".
Or you could just book another flight 😀
- Log in to post comments
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
- Log in to post comments
Open Exchange applications:
Certifications & Credly badges:
Followers:
Following:
Peter has not followed anybody yet.
I see that you added this in manual mode - I am not sure if you did it this way for testing purposes, but if you create a calculated measure (similar to how you have defined "adjtotal"), then your pivot will be more user friendly to modify in the future. Once in manual mode, you won't be able to drag and drop anything to the row/column/measure/filter boxes anymore