hi
i have a straight table in my dashboard that should show the count of two thing for each office and it can be filterd by date.
when i chose some date, the straight will show the office that have value on their expessions, but i want to show all office.
for example when i chose year 2014 i want to see sth like this:
| Office | Count(A) | Count(B) |
|---|
| 100 | 10 | 20 |
200 | 12 | 15 |
| 300 | 10 | 0 |
| 400 | 0 | 0 |
but normaly straight shw sth like this:
| office | Count(A) | Count(B) |
|---|
| 100 | 10 | 20 |
| 200 | 12 | 15 |
| 300 | 10 | 0 |
because office number 400 have no value for both experssion
what should i do?
