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
Repeat Data Rows based on Start and End Date
I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will
ERROR - Calculate Hours Remaining p/Day
I am trying to use the query to calculate the number of hours needed p/day based on the number of hours left on a job and the number of days until its due. This is just part of the total query I am writing The problem I am having is that when I code to
Unable to import data from Azure SQL due to unsupported date format
I am having trouble importing data from Microsoft Azure SQL Database. My tables have a column of datetimeoffset(3) type which Zoho doesn't identify as Date. If change the Data Type to Date manually, it will result in the following warning: "The chosen
Counting the number of times a given transition in a blueprint has been performed
Hello. Is it possible to make graphic in Zoho Analytics of the number of times a given transition in a blueprint in CRM has been performed? In this case, I want to know the number of times the transition 'Offerte verstuurd' has been performed. CRM offers
Incorrect Time in Reports
In the column I've set the column to current date. My time zone is EST, yet for some reason, if I edit a field, it's already so far ahead that it labels the cell as tomorrow (10/4 -- it's 10PM here 10/3)
Dashboard data permission based on user
Hello, We have a dashboard full of widgets, charts, ... with data from different applications. How is it possible to share this dashboard filtered so that each logged in user (non admin) only sees their filtered data in that dashboard? Picture in attachment
Dashboards not visible
Hello, I have shared a dashboard with 2 non admin users with the exactly same filter to only see their own data. They also use the applications exactly the sames way. How is it possible that one of them has 0 data in Analytics ? see attachments tha
Next Page