Hi,
I have two tables. Both of them have a colun with a date of it.
Bot tables i do add a new column of Month(Date) As Month and Year(Date) As Year.
This means both of the tables are linked with at least those two entries.
Table1:
Number, Date, Month(Date), Year(Date)
Table2:
String, Date, Month(Date),Year(Date)
Now i create a chart where do a Count(String) and filter for a Year. That gives me a Chart of how many entries in Table Two are in each month.
If i do set an extra filter for Number, some Month disappear from my chart because in Table 1 there could be a month without entries but in Table2 there could be some entries.
How can i make it the way that
1. If entries in Table1 and Table2 -> Show the count (That is working)
2. If no entries in Table1 and some entries in Table2 -> Show the Count
3. If no entries in Table2 and some entries in Table2 -> Count is 0 (I think that might work by default dont have one of these cases yet)
4. If no entries in either Table -> Show count 0
This way my chart will always showing 12 Months in a year