WE NEED THE ABILITY TO DO A LEFT JOIN WITHIN THE SISENSE DATA MODEL

Another vote from me

Another vote for allowing LEFT JOIN !

This is an absolute need to have feature, what kind of BI tool does not allow to have Left Joins??

We kindly urge Sisense to take this feedback seriously, as I can see it is affecting a multitude of customers (46 likes when I posted this). What else would you need to make this feature a priority??

Looking forward to Sisense's urgent action on this!

+1 same for me. I have been struggling for a month now because I can't find a solution to my problematic without Left Join.

+1 for left joins. Really needed and there's no way around it for us. 

I'm also struggling with the limited flexibility to customize joins, particularly in tables. The workarounds described in this thread are functional but they are cumbersome, time consuming, and inefficient. The functionality of the software would be much improved if there was an option to include all values from a particular column even if there are no corresponding matches. 

For what it's worth my specific use case involves showing a count of items per a given timeframe - we need to see zeroes instead of gaps in our data.

Adding a voice to the chorus calling for this feature. Except it shouldn't even be a feature, how can a data analytics platform be missing such a basic function of data analytics?

The possible "solutions" floated to address this, including ones we've received directly from Sisense, are inefficient and resource intensive, and are just all around poor practice.

Please provide us with the functionality that frankly this software should never have been released without. It should not take well over a year of people asking for this for Sisense to realise they have effectively delivered a nerfed product.

We keep stumbling upon that. This feature would be great!

I also found this article that may be of use: https://community.sisense.com/t5/knowledge/how-to-perform-left-join-in-the-dashboard/ta-p/8589