YouTube Analytics
Hi, Why after Zoho Analytics and YouTube synchronisation we can't find anywhere information related to the revenue generate by our videos on YouTube. And there is NO OPTION to find the YouTube RPM (mandatory to calculate YouTube revenue) of our channel
One dashboard with data from Zoho Books and Zoho CRM
Hello, I would like to create one dashboard with data from Zoho Books (example: account receivables balance) and Zoho CRM (example: number of new deals created). I've already connected both CRM and Books with Analytics. However they are in separate workspaces and it seems that I can't reach Books while I'm in CRM workspace and vice versa. Is there any way to have in one workspace both modules? Or is there any other way to have one dashboard with KPI;s from CRM and Books. Regards, PJ
formula
i have made a custom calculation function with if condition and it works but doesn't want to get the subtotal amount of it and get 0 although there is data in the same table with subtotal works in amount field but not a custom function and i need to use
Setting up Commissions for Reps
Commission information We use sales Reps Each Sales Rep earns 8% of the profit from their jobs (Job income less Job expenses) In the past, I've used QuickBooks and run a P&L by Customer to figure this out, but am now trying to see how we can use Zoho
Deleted Users - permanently delete or edit
Now we are using Zoho Analytics, user details are visible in the user table but where we're having to match on name as opposed to Id at times, this is casuing problems. How can I edit the name of a deleted user, or stop them being migrated to analy
Labeling in a bar chart
Hi all, I created a bar chart from data from different columns in a table. But the output is that such the actual bars are not labelled and instead it's all listed in a legend. Is it possible to lable the individual bars in the chart (rather than showing
About ZOHO Analytics 5.0... information
Hi all, I have spoted that there is a new version coming on ZOHO Analytics 5.0. I could not find in this group any information on it like demo of the new feature from ZAnalytics 5.0. Is there any available info ? Cheers Thomas
Cross-domain AJAX to enter table rows
When I saw that you have REST API I took for granted that you will be able to accept cross-domain AJAX requests from browsers by implementing the correct HTTP headers. I build an app based on this, it never came to my mind that you would miss such a feature. Is there any reason whatsoever that you don't have one CORS HTTP header Access-Control-Allow-Origin: * ?????
Where are the linking modules from CRM
Hello, I'm working on reports from CRM data. I 've some customs modules and 2 linking modules automatically created by a mulit-select lookup field in the layout of modules. In CRM I can see these modules with datas inside In Analytis, I can see all datas from all modules except linking modules ! Is there a way to get the linking modules to be synced in Analytics ? Thanks for your quick answer E charrier
Error while entering public URL for ZCreator report in Zoho Analytics while Importing through Feeds/URLs option.
Hi, I am trying to create a better report in Analytics for one of my Creator application, but while trying to enter report public URL through Feeds/URLs option, its not displaying my data correctly rather it displays HTML code in spreadsheet. See screenshot
Help with formula column
I have a numerical entry in an existing column and I want to simply provide a True or False statement to a formula column. Example - this is what I have Name Number Row 1 Smith 10 Row 2
Same data, different dates
I'm exporting stock data out of our platform. Technically , the products will stay the same. The quantities & value should change. But as i'm pulling this data weekly, how do I append data onto the table and it reflect the data but just with the different
Modifying Axis data into hours and minutes
Hi I would like to modify the Y-axis data into hours and minutes. How can I do that? I create a new data column that is modifying seconds into hours and minutes, but the data type is "plain text". I think I'd need to have it in "number" in order to be
Tip of the Week - Edit Aggregate Formulas from your Report Designer
Did you know that you can edit your aggregate formulas from your report designer area? You do not have to navigate between tabs to edit your aggregate formula while working on your report creation. Let us see how this can be done. On the left panel of
jounal
As per below your report its include journal entries?.. Also payable & receivable are not an bank or cash transactions, as per our request we need Organization inward amount & outward amount total, for example Customer payment (its fund inward our organization)
Forecasting in Zoho Analytics
I implemented revenue forecasts on my charts, However when i use a filter on the dashboards, I lose the forecasts for the filtered values. How do i retain the forecasts after filtering the dashboards? Thanks, Gilbert
Export as HTML error
Hi, I have a dashboard and I'd like to export it as a html. When exporting it as html the export file contains an error, when I try to send it by email as an attachment I get the following error: Could you please support me on this? I've shared the dashboard
Report Condensing
As I start a new financial year for a dashboard tracker, i'd like to only show the last previous 3 months as I add the new year. Is there a best way to show this without creating a new dashboard? Thnaks
Date Filtering - Why So Difficult?
Why is it so difficult to date filter across data sources? I have two Creator forms that I have as data sources. Each has a date field. I can make a Summary Report that has columns from both forms as well as calculation columns that calculate values based
Track Conversion rate between stages inside Deals Module
Hi, There exists a feature to track the conversion rate between the modules in CRM. say: 45 % conversion rate from Leads to Deals as you can see in the below screenshot. This can be assessed by going inside dashboards-> deals dashboards-> add component->
Set Geo data type for Zoho CRM Analytics
It would be nice if we could use address, city name or zip code from Zoho CRM standard fields to generate Geo Map chart. At this moment, when I try to change the data type to Geo, let say Country or Zip code or City, it says : "Sorry [TableName] is a system table in this workspace. You cannot modify its design" I was told by Zoho Analytics support to get in touch with Zoho CRM to change the field type, but that has nothing to do with data source... it is related to mapping in the Zoho CRM connector.
Comparar datos de un mes respecto el mes del año anterior.
Me gustaría comparar los datos de un mes en concreto respecto los datos del mismo mes del año anterior y cuando cambie el mes natural, automáticamente se actualice solo. Por ejemplo: Ahora me gustaría ver las ventas del mes de marzo respecto a las ventas
Filtro por fechas de diferentes tablas.
Hola, Me gustaría saber si en un gráfico tengo dos valores en el eje Y que provienen de diferentes hojas de datos ¿cómo puedo poner de filtro la misma fecha? El campo fecha está en cada una de las tablas de datos.
Woocommerce Product Table List
Hello EveryOne, WooCommerce Product Listing Plugin is the Easiest, Fast & Awesome way to list your WooCommerce Products Items in responsive, user-friendly table view or order form with a quick view option.
Error de sincronización con zoho databridge
Hola! Tengo una consulta de SQL Server que se sincroniza c/3 hrs, desde el viernes pasado marco un error relacionado con Databridge, revise las conexiones y aparentemente todo esta bien. Revise la conexión a detalle y me sale este tipo de error Se revisa
IF statement to Convert TZ before and after time change
Hello! Background: I use "convert_tz("last_received_at", '+00:00', '-05:00')" in a formula column to adjust a date from UTC into Eastern time. After the recent time change for Eastern, I need this formula to continue to adjust for -05:00 before March
Ask the Experts #18: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event - Ask the Experts #18 on 24 March 2021 between 05:30 AM - 10:30 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with
Baseline Data missing from Zoho Analytics
Baseline data is not available in the standard projects data extract making reporting to baseline impossible.
Dash with a default result
I applied a filter criterion to a report link. But by deleting the piece of the criterion, the user can see all the results of the report. How to leave the link with a default result ???
Is it possible to remove the names of city / region / country on the Map - Scatter chart ?
Hello, I would like to see this map without the labels ! Is it possible ? Thanks
Graph labels
Is it possible to have a a graph with multiple columns where the column labels are shown below the grapth (instead in a legend like shown in the image here)?
Aggregate formulas in tabular view?
Why can't we use aggregate formulas in a tabular report? Why is such a simple feature missing? This says that you use aggregate while creating "all reports" and "as you would use a column in a table", but tabular reports are not included so you can't
How to Connect with 2 different Organization with 1 Data-bridge
Hi, I have as issue I have 2 different Organization with 2 separate Database at 1 server and I have connected 1 Database to 1 organization using Databridge. But when I'm trying to connect with other Database with another user it's saying download Databridge.
Connectivity with SAP BW BEx Queries
Dear Zoho Analytics Team, SAP BW is an Enterprise Warehouse in SAP ERP and we have SAP Business Explorer (SAP BEx) tool to create reports on SAP BW. We can connect to SAP BEx queries using SAP Business Objects (BO), a reporting tool like Zoho Analytics.
Is there any way to translate months?
Hi, When i make a SQL Table i Want a column to have the month, but if I use absmonth() or month() I get the month name in english. Is there any simple way to translate the names to spanish?
Drill Down
Dear Team, Am trying to add all columns as drill down path using below option while sharing link. It is not working. Added in individual reports also, but some random column names come as drill down option.
ZOHO_CRITERIA not working with LIKE
API is working fine pulling data when using ZOHO_CRITERIA as $critera = "column = 'value'". However, in the API docs, it says that you can pass any SQL WHERE arguments including LIKE statements, which are not working. $critera = "column LIKE '%val%'"
Pivoting a selected dataset at source itself
Hi Team, We have Query table for Pivoting a dataset. But we don't have a feature to Pivot the selected dataset at source file itself. In Tableau, we have the functionality to pivot the selected dataset at excel file itself. We can see Pivot option at
How to get a Column Series into Rows Series in a Chart
I have data like the below table. Years are as column headers corresponding to City. City 2010 2011 2012 2013 2014 2015 2016 Chennai 12.5 22.5 34 23 36 39 45 Bangalore 23.6 24.8 30 34 34 38 49 Vizag 13.9 23.9 20 43 45 40 44 Hyderabad 34.8 44.8 39 23 36
Zoho checkout data in Zoho Analytics?
Is it possible to import Zoho checkout data into zoho analytics?
Next Page