Help with KPI Widget for Stage History (CRM)

Help with KPI Widget for Stage History (CRM)

I am a Zoho Partner, and I have a client that needs an Analytics Dashboard Widget that will display all Deals that were in "Proposal Sent" stage in the last 365 days.  The problem is that some of the Deals entered that stage twice and are duplicating the results due to that.  So, how can I set up a widget with a count of all Deals that were in Proposal Sent stage but disregard any that were in that stage multiple times.  

Example:

ABC (Deal) = New
ABC (Deal) = Negotiating
ABC (Deal) = Proposal Sent
ABC (Deal) = Negotiating
ABC (Deal) = Proposal Sent
ABC (Deal) = Closed Won
XYZ (Deal) = New
XYZ (Deal) = Negotiating
XYZ (Deal) = Proposal Sent
XYZ (Deal) = Closed Lost

Widget:
# of Deals with Proposals Sent Last 365 Days = 2 
(eliminates the extra Proposal Sent on the same Deal)

      Zoho Developer Community








                                Zoho Desk Resources

                                • Desk Community Learning Series


                                • Digest


                                • Functions


                                • Meetups


                                • Kbase


                                • Resources


                                • Glossary


                                • Desk Marketplace


                                • MVP Corner


                                • Word of the Day



                                    Zoho Marketing Automation
                                            • Sticky Posts

                                            • Announcing Zoho Analytics 6.0 Beta!

                                              We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team
                                            • [Upcoming Webinar] Fostering a data-first culture with enterprise analytics

                                              Businesses today are fully aware of the importance of being data-driven, and there are countless companies catering to their needs. Technology and software vendors, specialized management firms, and more enable businesses to set up and maintain their
                                            • We are coming to your city! Zoho Analytics Community Meetup

                                              Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing
                                            • Zoho Analytics: 2021 Look Back

                                              As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021
                                            • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

                                              Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO


                                            Manage your brands on social media



                                                  Zoho TeamInbox Resources

                                                    Zoho DataPrep Resources



                                                      Zoho CRM Plus Resources

                                                        Zoho Books Resources


                                                          Zoho Subscriptions 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







                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now