Group by and SUM
Hi everyone,
I want to group all the campaigns (there are 4) and add (total) the clicks and the amount (importe). I have this but it gives me an error. SELECT Campaign, Clicks, CTR, "Importe" FROM "AdWords (Google Analytics)" JOIN Tratos WHERE Fase
What does the Modified Time in Stage History referring to and what can I do with it?
I would like to see a widget that presents the number (counter) of deals that changed to a specific stage in the last 7 days. How can I do that?
A Complete Overview of Zoho Analytics
Zoho Analytics is one of the finest self-service BI and data analytics software that allows you to analyze data, create amazing data visualizations, and discover hidden insights within minutes. It provides cutting edge analytical solutions that are needed
Sales Month on Month & YTD Sales Excluding Current Month
I have sent this through to Zoho Support however so far they havent been able to come up with an answer. I have 2 problems to solve as follows: Sales Month on Month Calc I would like to create a widget that shows the sales for last month (e.g. Mar 22)
Sales Commission Dashboard on GP
Hi, I want to create a dashboard for hte salesperson's to know their achieved targets and commission realtime from zoho books. The scenario is that the sales person has a minimum sales Gross Profit GP target of 20,000/- After pass 20,000 and till 30,000
Integration of Status Timeline from Zoho Projects to Zoho Analytics
In Zoho Projects, we have a way to find out the status timeline of each tasks in a specific project. Currently, we don't have a way to pull that information up in bulk, like being able to consolidate the status timeline of all tasks in one report. But
Add/ split X axis
I have the following requirement Y axis - sales X axis - state Department Color- product I want to plot a graph , showing sales on y axis and splitting X axis in to two axis [ state and department ] and in color in need to differentiate
Model diagram add relationship path
Hello, How is it possible to add a link in the model diagram (a new path between 2 data tables) ? In attachment the link exists for the dates (in green) but I would like to link "user" to "visits report owner" (see red link). I cannot add a path in "configure
Previous month vs same month last year Widget
Hi guys, How do I add a widget that shows previous month ( march) vs same month last year (march 2021) ? Br, Robin
Aggregate formula with multiple conditions
Hi All, I am trying to use aggregate formula with multiple conditions but it is throwing me an error. Formula : sum_if((is_previous_nmonth("Current Year Primary"."Current_Month_SRD.Date",1))AND("Current Year Primary"."Current_Month_SRD.Date"<=previous_nmonth(
Zoho project feed status report
Hi, we had a Zoho Projects and a Zoho Reports subscription. We are using FEED -> Status to include a brief summary of the project status and it's evolution. It's quite useful for getting a log of project evolution. Now we want to make a report to show this entries in a PDF or similar but we can't get this entries, even using zoho reports We can't find the table we can query to get this entries so we don't Know how to make a report with the project log. Is possible to make this report? If not, how
Tip of the Week - Customizing the Fiscal Calendar
Does your company’s fiscal year start in a month other than January? Do you have issues determining the outcome of the reports for your organization with a custom fiscal year? No worries. Zoho Analytics provides options to customize the fiscal year to attune with your company’s calendar. Not only year, the starting day of your week can be customized too. Let us see how to set the fiscal year and week in the below animation.
How can I create a dashboard from various workspaces (E.g. Zoho Books, People & Survey)
I would like to create a dashboard with various company wide KPI (Finance, Sales, HR etc) Is there a way to get thus different workspaces in one dashboard?
Xero Showing $ not £
Hi I have synced my Xero company but everything is showing $ and not £. The actual figures are correct as at GBP. Is there any way to change this please? Thanks Dave
Business_hour (by minute)
Hi Zoho Team business_hours formula can only give the difference of time or day between two dates. (In the time calculation, it can only calculate the exact time. For example, it can give the difference between 16:30 and 16:55 as 0.) I want to calculate the minute difference between the two dates by specifying the working hours. How can I calculate the difference in minutes using this formula. Thanks
Rename API data after import?
Hi, I am creating Analytics reports based on data that is being pushed to Zoho through API. I am working with the API data from my company's database, but this data is not very user-friendly. Is there a way to rename some data after it's pushed to Zoho?
Clickable dashboard view via email?
I want to send a weekly recurring email with a clickable dashboard view embedded within the email to people outside of my organization. The view is supposed to look like a web page. I'm using the Zoho Analytics web platform and would like to know what
Issue with colours on my Ring Chart
I have a ring chart with colours assigned to them with specific meanings: red, green, blue and grey. When one of them is missing the colours don't align eg: red becomes grey, grey becomes green. Is there a way to make sure that the colours stay where
Best way to deal with summer time ?
Hello, This weekend we had to change hour in a lot of countrys, this impact my indicators because the office opening time is an important information. I found a formula to take this in account but wontering if there is a better way to do it. I am in France
Sharing Dashboards and reports in Zoho Analytics
I want to send a weekly recurring email with the dashboard view embedded within the email to people outside of my organization. I'm using the Zoho Analytics web platform and would like to know what are my alternatives to do so.
Grouping data for charting
Hello Guys, I have a dataset which looks something like this: Delivery Date | Courier 01/01/2011 DHL 01/01/2011 DHL 01/01/2011 DPD 01/01/2011 FEDEX ..... I want to draw a pie chart, which gives me a percentage of deliveries carried out by each courier. The problem is that the pie chart only allows for something like 25 datapoints - in a world where we have more than 25 couriers this becomes a problem :-) What I want to achieve is a chart that shows the break down for perhaps the 10 most
How to integrate Zoho Analytics with Google Analytics?
I am new to Zoho Analytics. I wanted to set up Zoho Analytics for my site. I wanted to Integrate Zoho Analytics with Google Analytics. Can I do this?
Aggregate Formula "CALCULATE"
In zoho analytics is there a similar formula to "CALCULATE" of power BI? I need to sum data from a specific year
Calculate Business Hours for Contact Resolution
Hi, I've got a table that gives me a datetime expression for "case creation" and "case close". I would like to find how many Business Hours a case remained open for as contact resolution is one of our KPI's. Case Creation Example 2017-09-25 14:15:07.000000 Case Closed Example 2017-09-25 16:06:02.000000 Business Hours Monday to Friday 09:00 AM to 18:00 PM Is there a formula that would allow to do this? Thanks
Sincronización de la información del rol de contacto de Zoho CRM a Zoho Analytics
Hola, Tengo problemas para sincronizar la información de los roles de contactos de los leads a Zoho Analytics!. ¿Esto es posible? Muchas gracias
Get info from "incorrect" JSON from Zoho Analytic
Hello all, When you get info from the Zoho Analytics API, the JSON sometimes comes in a incorrect form. I am getting info from a report and the JSON comes this way { "ID":"81921000005496719", "Name":"Product1", "Total":"110.00"},{ "ID":"", "Name":"",
accessing zoho's student reports in moodle
Hi all, I want to track my students progress. I am having all students data in zoho. Now i want to fetch that data in Moodle for preparing reports. How can i achive this ?? can anybody tell me is it possible?? is possible then what steps do i need to take??
Table 2 different data sources
Hello, When I create a table there are 2 columns: A column for Application A (based on visit report owner which is full name of user, example: Jonas Hardy). This column shows achieved number of visits. A column of another Application B (based on selected
add SQL Function
Hi Can you add the SQL function EXISTS please. As one thing I need to do quite often is set pivots up for people that HAVEN'T done something. and because they haven't done it, the record does not exist in that module. therefor i can provide a count
How to Create a Lookup from a Query
I have a Query, I would like to lookup a column to a table in another report. Now for tables, it is easy enough you just select Edit > Lookups and then Join the two tables. Problem is I need the query's column to be the "Column from current table" and
Unsupported function used in query
In the image below, the highlighted line of text is what is causing the problems Basically, what I want to do in this query is return the "DeptEstEnd" (which is a date) AS "Capacity End Date" when this date in the query is greater than or equal to the
Conditional Formatting
Hi All, Can i do a conditional formatting based on another column in pivot report?
Events / Milestones ➝ show these in all data sets
Hey all, Is there a way to add an 'event' as a date and have that then referenced in all data tables with dates. As an example, If I turn off facebook ads on a certain date. If this 'event' shows up on my data, I can see how this change affects multiple
User filter default logged in user
Hello, Is it possible that the default logged in user is selected in a user filter on a dashboard ? In this case for example if Mathias logs in on the dashboard that he will be automatically selected in the user filter ? See attachment Thanks
Twitter Analytics Synchronization Error
Zoho Analytics has not been synchronizing with Twitter for the past two weeks. Zoho Social is still synchronizing, but unfortantely the capabilities differ greatly with what you can do with the data in each platform. Is anyone else having this problem?
[Webinar] AI in BI: Automating and Accelerating Business Insights
Hi there, In a post-covid world, companies across the globe are increasing their AI investments to accelerate their business insights from data. Ventana Research’s Benchmark Data & Analytics study shows that 87% of organizations currently use or are planning
Amazon Seller Central
Is there a way to get data out of Amazon Seller Central in to Zoho Analytics? I currenly download monthly reports from Amazon and import them to Analytics. Thanks
Running total skipping blank days
Hello, I have a graph in analytics where I have a goal field for how many sales I want to make each day. The problem is when there are no sales made on a day it is left blank and the running total field that is adding the goal values together each day
Report of the Week - What-If Analysis (Influence of Discount over Sales)
When an archer is aiming to hit the bullseye (or a sniper, her target), she has to consider external factors like gravity, wind direction and wind speed. Similarly, when running your business, you will have to ask various questions. Have you aligned yourself
Exclude max values for column
Hi, I want to find a list of who needs their software upgraded. So basically I want to find the 'installed version' and exclude everyone who has the latest version. This seems to have the best clue, but I can't get it to work- https://stackoverflow
Next Page