Create a dashboard with a formula in Analytic
I need to know the average date of purchase per a product per a customer.
Here is how I count it.
Customer A bought product B in Jan. I count it "1"
Customer A bought product B in Feb. I count it "1"
Customer A bought "0" in Mar. I count it "0"
Customer A bought product B in Apr. I count it "1"
Customer A bought product B in May. I count it "1"
Customer A bought "0" in Jun. I count it "0"
Customer A bought product B in July. I count it "1"
Customer A bought product B in Oct. I count it "1"
Customer A bought product B in Nov. I count it "1"
Customer A bought "0" in Dec. I count it "0"
Add all the number "1" and "0" I have "7" , then I divide with "12" (month) 7/12 = 0.58333333333
then I multiply it by 30 (days) 0.58333*30 = 17.5 (days) as an average date of purchase per a product per a customer
How can I add this formula in to Analytic as a Dashboard?
In this Dashboard, I just select customer, date of time and product, and it will show me the number, just like the attached image.
Thank you so much for reading.
Ask the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion
Announcing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data Preparation
Free Webinar: 5 Must have inventory reports for online sellers | Zoho Analytics & Zoho Inventory
Hello All, Selling goods online? These 5 inventory reports will help you make better informed decisions. Join us on this free webinar hosted by Zoho Analytics and Inventory domain experts to learn more. Register now! Friday, December 13th: 9am PST
Zoho Reports to be renamed and launched as Zoho Analytics 4.0
We made the Zoho Reports 4.0 Beta announcement a few months back. As we worked on new features in 4.0, we realized we are moving away from just Reporting, and getting more and more into the Analytics realm. And that's the reason why we have decided to rename Zoho Reports as Zoho Analytics. This post is just to give you a heads up on the Zoho Analytics 4.0 launch in mid November 2018. As present users of Zoho Reports, be assured that the new product will continue to work the same as the current one.
Zoho Reports Release 4.0 Beta
We are delighted to announce the new Zoho Reports Release 4.0 Beta. Your favorite Zoho Reports now comes with a fresh new-look and exciting features. The new Zoho Reports 4.0 includes the following features: Dashboards in Single Click The UI has been completely revamped focusing on easy navigation. Now you can access any dashboard in a single click using the Preview Cards. Easy Navigation The main navigational elements are made bolder and bigger now. The analytics elements are organized into three
Zoho SalesIQ Resources
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
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.