Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
USERS:
Load * Inline [
name, user_id
a, 1
b, 2
c, 3
]
;
EVENTS:
Load * Inline [
title, user_id
LaLa, 1
];
If I want to display all EVENTS with the data as below in the Table, it of course displays all the users, and their events if they have any. Now my goal is to not show the rows if a user does not have any associated event. I see two options:
1. Filter the USERS table in load phase by some kind of WHERE statement.
2. Use a chart expression when adding user_id as dimension to the table.
For both of the above I don't know how to do it and I have searched around quite a bit.
basically you want to hide b and c rt.
if so in the table for dimension title disable 'Include null value'
basically you want to hide b and c rt.
if so in the table for dimension title disable 'Include null value'
It really was that simple 🙂