how to auto-update columns in zoho analytics table?
Hi! I use google spreadsheet as data source with many worksheets. In worksheet there are changes in columns - few old will be deleted and some new will be added. How to auto-update columns in resulting table in zoho analytics? So that in google spreadsheet there are new columns - and such columns automatically appear in zoho analytics corresponding table too. How to turn on such auto-update of columns in zoho analytics corresponding table?
Automatically migrating graphs and charts to external website
Hello, Does anyone know if it is possible to have graphs and data automatically migrate to an external website? Is this something Zapier can do? I want a place my clients can login to and see their reports. I would prefer not want to have my clients have to sign up with a Zoho email to access the reports straight in Analytics. We want a branded website that houses all the reports. Hopefully this makes sense. Any ideas or suggestions would be appreciated.
Import Report from Desk
Good day, Is there a way to import an existing report from Zoho Desk into Zoho Analytics and improve the report in Analytics. Thanks Rudy
Ticket ID
I am trying to create a basic aging report but have a bit of a difficult time getting some of the data across. Sample report: Grouped By: Ticket Owner Customer Name Status (open\Closed) Body of report Ticket ID (only able to see a long number in a range) Subject Ticket Created time Ticket Closed Time Resolution time (time between open and close) (only getting "1" as a value Total Time Spend (time tech spend on ticket) (only get
Is there a way to have an external URL open when a user clicks a record on a dashboard or report?
Hi everyone, we have a custom CRM system we built and we were looking at Zoho for its reporting capabilities. So for example we might have a chart on a dashboard that shows opportunities, with how many are in each stage of a sales funnel. If I click on the opportunity name, I'd love it if it was able to open a new tab and go to a URL that I specify, being the URL to this record in our CRM system. That way users can be browsing a report or dashboard in Zoho and easily still click to then work on
Modificación de gráficas
Buen día seria muy practico que se pueda planificar el espacio de trabajo desde un comienzo, no solo con los colores si no también con las lineas que se van a utilizar y los diferentes tipos de letra, ya que si se debe hacer una modificación esta se realice desde un solo punto y no abriendo cada grafica una a una para generar un cambio de forma, color o diseño.
Symbols/Icons within tables, conditional formatting
Hello, I would like to use symbols/icons in a table, depending on the value of the cell. When using conditional formatting I can only configure the color of background and the text. Doesn´t Zoho Analytics (demo) offer this feature?
Make URL fields clickable in reports
It would be great if when including a project URL field in a report, the url field is actually clickable.
Vista de espacios de trabajo
Buen día, seria muy bueno si pudiera organizar los espacios de trabajo en carpetas, es decir, si tengo 3 administradores de espacios de trabajo que pueda crear una carpeta con los proyectos correspondientes a cada administrador, o mejor aun aun, que pueda generar carpetas para organizar mis espacios de trabajo como desee.
Adjust data to analyze daily Sales values (Columns) with the Date Range inserted in Top Row.
I am trying to upload data to Zoho Analytics, but same is in an odd format which is making it difficult to work with. I need to analyze the daily Sales value (Columns), using the Row Date range. Please if anyone has a suggestion on how to arrange this type of Sheets so that I can feed Zoho Analytics properly. See attached Sample Sheet. Thanks,
Updating Records Using Databridge
It has been a while since I imported data using a local mysql instance, but I am trying to set something up right now. Anyway, on the "how do you want to import" part of the setup, I do not see an option to add new records and update existing records. In fact, the two options not greyed out at "add records at the end" and "delete existing records and add". With this, it seems like the best option would be the delete and add option. My question is - Is this a fast process? Based on what little online
New Features rolled out on Aug 2, 2019
Emailing Reports - Recipients Limit Extended Number of recipients for emailing reports & dashboards has been raised from 5 to 25. You can now specify upto 25 recipient mail ids when you mail reports. You can also add Groups as recipients and no longer need to enter all email addresses every time. Learn More... Selecting multiple views made easy Shift + Click short cut key can now be used to easily select a contiguous list of views easily in the Explorer.
group_concat trouble with a query
I am having trouble with line breaks being inserted into group_concat string when the value is non-existent (null). So here's the (joined) table, for example: Letter | Number A | 1 B | 2 C | null D | 4 E | null F | 2 so if I do: group_concat(DISTINCT "Number" SEPARATOR ', ') I would expect result being: '1, 2, 4' However, whatever I tried, I am getting: 1, 2 , 4 Can anyone help?
Zoho Analytics Performance Issue
Hi All, What kind of backend is Zoho Analytics running on? I have a dashboard - one one table with about 60K rows. The dashboard is not coming up and is taking for ever. I am not even able to edit the dashboard. Check it out here on https://culytics.com/blogs/cu-peer-benchmark. Their support is closed for the weekend. Best
Mongo DB import objects
I am trying to use the Upload Tool to import data from Mongo. When I manually import from JSON, it works, but I'm getting issues with the Upload Tool. The format of the collection is something like: {_id : 12345, name: "Andrew", cars: [ {make: "Toyota", model: "Matrix"}, {make: "Toyota", model: "Prius"} ] address: { number: "123", street: "Main Street", city:
Uptime software connected to Zoho Analytics
I'm just curious if anyone has connected a service to display their internet's uptime and latency with Zoho Analytics. If so, what services are you subscribed? Thanks!
Last/Previous month in relative date filter
In the relative date filter, what is the difference between "Last 2 months" and "Previous 2 months"? So, if we are on 25-July, then is my understanding correct of the following: Last 2 months :=: 25-May~24 July Previous 2 months :=: 01-May~30-June Thanks.
Connecting time tables
Hello all, Is it possible to link/connect the date tabled so all the dates are synced? Now, when I am selecting for example Q4 of 2017, not all the graphs are changing to Q4 of 2017. Thanks!
How do I edit custom query in Data Sources for Amazon Redshift data import?
I set up a custom query on data import for Amazon Redshift, but now I need to do a small adjustment. I can't find a way to edit the custom query, anyone knows how to do that? See screenshot attached, table name is "mpe_rpt_list_snapshot"
Analytics - IF formulas
Hi there, I'd like to create a formula to calculate the duration between 2 session time, but also return null if the duration is > 30 minutes (reason : these are false value, bug related, don't want to display them...) So I tried If('Timediff("sessionEnd","sessionStart")' > '00:30:00','null','Timediff("sessionEnd", "sessionStart")') but I only get null result, even when duration is less than 30min. Anyone know how to solve this ? Cheers Olivier
New Features rolled out on July 24, 2019
New Data Connectors We're happy to announce that Zoho Analytics is enriched with two new Advanced Analytics connectors: Advanced Analytics for YouTube Channel and Facebook Competitive Analytics. Advanced Analytics for YouTube Channel Advanced Analytics for YouTube Channel allows you to monitor and grow your YouTube channel by analyzing its performance with powerful insights. You can measure video engagement by analyzing your audience interaction such as likes, comments, shares, favorites, and
Do you work on Zia's abilities?
When I try to ask some simple questions about my data, Zia is not capable to correctly parse the sentence or at least understand that I'm asking about some specific data from the dataset. Do you work on enhancing Zia's capabilities? Could you please inform us about the status and the roadmap of this feature.
Analytics - Reports
Hello, everyone, it is possible to enter in Analytics in certain fields that I want to see all results that are not in a certain level. For example, I would like to see all sales opportunities that are not in the level Existing Customer Contract Renewal. If possible, it would be nice if you could tell me how this works. Kind regards, Ronny
Pivot Table Calculated Formula Columns
Currently, you can use formulas in the pivot table chart to create new calculated columns. I think it would be a good idea, and extremely useful to than run other calculations off those new calculated columns (currently unavailable as a feature). Example: Data Set Column 1 + Data Set Column 2 = Calc Column 1. (currently available) Data Set Column 3 + Calc Column 1 = Calc Column 2. (feature request)
Calculations
I would like to have calculations performed across rows as follows. I would prefer to do it in Zoho Analytics rather than in the table before loading it to Zoho Analytics. The data table has data for multiple CU Number. Any help is appreciated. Thanks, CU Number CUName Total Interest Income YTD Total Non-Interest Income YTD Reporting Quarter Interest Income for the Quarter Non-Interest Income for the quarter 19976 FIRST TECHNOLOGY $77,637,620.00 $25,655,201.00 2017:Q1 $77,637,620.00 $25,655,201.00
User Filters - group values?
Is it possible to group individual values in User Filters for Reports or Widgets rather than just displaying them individually? For example, if this is one of the columns in the table: A1 A2 A3 B C1 C2 D1 D2 D3 If I set an User Filter and list values, they all appear for selection, or I can choose which ones to include, however, I would like the drop town to read: A (includes A1, A2, A3) B (includes B) C (includes C1, C2) D (includes D1, D2, D3) Is that possible?
Buttons in dashboard per month/quarter
Hello, Is it possible to create a menu with the option to choose a year and at the other side choose a month or quarter? There is a method to add an option but I want to have this more clear with dedicated buttons so people can see in which year or period the dashboard is. Thanks in advance.
Stacked Line Graph
It might be a great idea to allow stacked lines in Analytics. Currently, this option is only available in a bar and area graph.
Use of Functions in a Summary View
I have a calculation that uses an "IF" that I would like to use. Unfortunately, the Formula feature in the Summary View does not permit the use of Functions. Why is that?
How to find the number of API units consumed?
I am testing the Zoho Analytics API and I want to know how many API units have been consumed till now. I am not able to find this information anywhere in the UI.
New Features rolled out on July 17, 2019
Prediction Interval for Forecasting Zoho Analytics now allows you to specify the confidence % in which the predicted data points are most likely to occur. Select the interval ranging from 75% to 95%. This option is applicable for the line chart. Click here to learn more on Forecasting. Send DMARC Compliant Emails To enable a secured mailing option, Zoho Analytics allows you to send DMARC compliant emails. DMARC policy is an email authentication protocol that allows both senders and receivers
Comparison Charts
Anyone using Zoho Corporation Analytics Suite. I am trying to find a way to add comparison charts to this dashboard - https://lnkd.in/gRy36_Z, so that we can compare CU results with their peers in the industry. I am running into some issues and want to get some help.
Compare same month over a couple of years
Hello, I am trying to create a bar graph that displays monthly performance between two years. So if i had 2018 to 2019 there would 2 bars side by side for each month. See attached my current report which is the one I would like to change. Any assistance would be very much appreciated https://analytics.zoho.com/workspace/1362170000000002003/view/1362170000000264196 Regards
Side by side graphs
Hello Hoping you can help. I'm wanting to create a graph which compares monthly figures between years. The graph would show jan 2018 and 19, feb 2018 and 19, etc side by side. It this at all possible? Regards Fernando
Zoho Analytics Issue with Comparison Charts
Anyone using Zoho Corporation Analytics Suite. I am trying to find a way to add comparison charts to this dashboard - https://lnkd.in/gRy36_Z, so that we can compare CU results with their peers in the industry. I am running into some issues and want to get some help.
YOY
an easy way to make a pivot with a yoy number. How is the revenue from 2019 compared to 2018 the same month? it should be nice and easy but it isn't...;
Include Manual Journal Entries from Zoho Books
Is there a way to access Manual Journal Entries from Zoho Books in Zoho Analytics? I don't see them on the list of tables to include when editing settings.
Line joining legend
Hi, Just getting started with ZA so please bare with me. One of my Pie charts has the legend to the right but the "value" is shown near the pie with an adjoining line. I just created a new pie which will only ever have two values and would liek the same lines. I've compared both sets of "gear wheel" settings in edit mode and they look the same. Any ideas?
Lightspeed and zoho Analytics
Would love to be able to access data and use Zoho Analytics to create reports and filter data www.lightspeedhq.com
Tip of the Week - Adding Trend Arrow in Tabular Reports
Adding a rise and fall arrow to your report is one of the best ways to visualize your data trending patterns. This is pretty useful in highlighting the trend or plotting against a target to show progression. Zoho Analytics allows you to add this comparison indicator to your tabular reports such as Pivot Table and Summary View. You can add them in a few easy clicks. The following animation shows how to add an indicator in your report. For more information on conditional formatting, refer here.
Next Page