Forum Discussion
Relationship - show lines with no values
HI All
I am trying to achieve something that in my head seems easy, but I can't find solution.
I have 2 tables:
- Stock - with sales indexes like this:
| index | parameter |
| a | x |
| b | y |
| c | x |
| d | z |
- second with sales, like this:
| index | date | sales |
| a | 1.2024 | 100 |
| a | 2.2024 | 50 |
| a | 3.2024 | 40 |
| c | 1.2024 | 10 |
| c | 2.2024 | 15 |
| c | 3.2024 | 13 |
There is one way relationship between those tables (stock filters sales).
I made matrix visual where I want to show all indexes from first table and sales if there was any.
I don’t want sales table to filter index table. I expect to achieve, something like this:
| 1.2024 | 2.2024 | 3.2024 | ||
| a | x | 100 | 50 | 40 |
| b | y | |||
| c | x | 10 | 15 | 13 |
| d | z |
It works ok for the indexes that have sales but indexes that have no sales are filtered, so i end up with such visual:
| 1.2024 | 2.2024 | 3.2024 | ||
| a | x | 100 | 50 | 40 |
| c | x | 10 | 15 | 13 |
Is there any way to avoid this filtering? is there somewhere option "show lines with no values" etc.?
I tried to change relationship type, run through settings but still no success.
I would really appreciate your support.
Thank you!
2 Replies
- DataInsights
Super User
- ArielKFrequent Visitor
Thanks a lot! I was pretty sure that I saw option like this somewhere, but I spent 2 hours digging through settings and finally lost hope. 😉