I have two tables, Subjects and Orders.
Some subjects have orders, some do not.
When trying to get a count of subjects, I only get a count of subjects that have an order in the orders table, since the tables are joined.
I followed this article:
But have had no luck, the numbers don't change. Here are some screens:
Alot of subjects have orders with an amount of zero, those ares are showing up fine, it's the ones with no order lines at all that get cut out.
I can get the number of subjects easily through sql, and in the sisense runner, and the numbers match up when I get only subjects that have orders to the number I'm currently getting.
Please sign in to leave a comment.