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?

Thanks


                  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

                                                            Tips


                                                          • Functions

                                                            Functions


                                                          • Meetups

                                                            Meetups


                                                          • Kbase

                                                            Kbase


                                                          • Resources

                                                            Resources


                                                          • Digest

                                                            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