Dates Missing when filtering data

Dates Missing when filtering data

I am having an issue with the charts and dates disappearing.

In the image below you can see bar charts. They are set to be on a rolling 13 month display, using the relative filter to include the last 13 months of data. When the data set is unfiltered, all the months are shown. But when I filter by customer, months when that customer has no activity are removed from the chart.

I have a date query that is used on the x axis of this report, and it is set to 'lookup' the data in a related table where the customer info is

How can I fix this?


                  Zoho Marketing Automation

                          Manage your brands on social media

                                  Zoho TeamInbox Resources

                                    Zoho DataPrep Resources

                                      Zoho CRM Plus Resources

                                        Zoho Books Resources

                                          Zoho Subscriptions Resources

                                            Zoho Desk Resources

                                              Zoho Projects Resources

                                                Zoho Sprints Resources

                                                  Qntrl Resources

                                                    Zoho Creator Resources

                                                      Zoho WorkDrive Resources

                                                        Zoho Campaigns Resources

                                                          Zoho CRM Resources

                                                          • CRM Community Learning Series

                                                            CRM Community Learning Series

                                                          • Tips


                                                          • Functions


                                                          • Meetups


                                                          • Kbase


                                                          • Resources


                                                          • Digest


                                                          • CRM Marketplace

                                                            CRM Marketplace

                                                          • MVP Corner

                                                            MVP Corner

                                                          • Word of the Day

                                                            Word of the Day

                                                                Design. Discuss. Deliver.

                                                                Create visually engaging stories with Zoho Show.

                                                                Get Started Now