Displaying row in table even when one of rows is missing.

Comments

3 comments

  • Avatar
    David Hertzberg

    Hi Tomer,

    You should try to add one measure with an aggregation of type "count unique" (this is the COUNT aggregation function).

    The result may depend on your precise elasticube design, but most of the time this is the result I get. If this is not working for you then you need to add a dummy row in your main table with the values you want to see, until the possibility to control the join type is available (still in the roadmap I think).

    I usually get this as an "unwanted" result to be honest. In this case, if you want to get rid of unwanted rows and keep only the one with a value, then you need to add a filter from the aggregation directly (using the filter icon from the calculation, on the left pane).

    Best, David.

     

     

    0
    Comment actions Permalink
  • Avatar
    Tomer Alon

    Thanks David, 
    Your comment led to me to better refine my search and I got to this article .

    Unfortunately, I need to display text and not an aggregated value. So I guess i'll have to create a custom table with left join from both tables.

    0
    Comment actions Permalink
  • Avatar
    David Hertzberg

    Great. The article you refer is very interesting. If you want something simpler, you can start with trying the trick with the count agregation. When it works, it shows 0 for the dimension that has no results.

    Best, David.

    0
    Comment actions Permalink

Please sign in to leave a comment.