Bar Chart to display 0 value
When using a bar chart, it just shows blank in the corresponding X Axis if the value is zero (0). When you use a line chart, the 0 is displayed. Is it possible that this can also be achieved in the bar chart? Bar Chart: Line Chart:
Get partial string before character
Hey everyone, I've been trying all sorts of things based on my knowledge in excel formulas, but impossible to get it done because the functions I normally use do not exist in Zoho :( I need to grasp the left part of a string column, after the first character '-' from the right : ex : "PR - SOLID STATE LIGHTING SOURCES - OVERVIEW" I need to grasp "PR - SOLID STATE LIGHTING SOURCES" Any ideas ?
Timespent in Hrs not correct - URGENT!!!
HI Folks - I'm trying to build a time report but running into issues. The "Time Spent in Hours" metric is showing "1 hour" but my StartTime and EndTime metrics only show 30 minutes. What is happening here? How do I get the TimeSpent in Hours to show correctly? Thanks!
New Features rolled out on Dec 2, 2019
Mark Reports as Filters in Dashboard Zoho Analytics now allows you to set Reports to act as filters in your Dashboard. With this, you can dynamically filter the entire dashboard by clicking on any data point of a report. This further enables enhanced user interactions with the Dashboard. Click here to learn more about Reports as Filters. Activity Logging Zoho Analytics' new Activity Logs feature can now enable you to track user actions/activities performed in your account. You can track activities
Best Dashboards
In Zoho Analytics, Its possible to do it this bullet and line graphics??? Attached a file
Support Chat Broken?
Hi, I've been trying to contact someone via the chat support feature all day and it is not connecting to anyone? Please can you advise me how I can perform either RANK() or ROW_NUMBER() in an SQL query in Zoho? I am looking to
identify terms spread in various columns and
Dears, I have a table with data spread in various columns. These data are "industry name" linked to a business opportunity For example: - Line 1 corresponding to business opportunity A, i can have the data "transformers" in column M - Line 2 corresponding to business opportunity B, I could find this same data "transformer" in column N - Line 3, corresponding to business opportunity C, this data "transformer will not appear" but other industry name such as "cable" will appear. Please find screen
User filters rearrange themselves
I have a dashboard with user filters in a logical sequence, bu for some reason, they occasionally rearrange themselves. I go back into the dashboard and Edit Design, and they have indeed rearranged. Anyone know why or how this happens? Or even better stop it from happening? Thanks Steve
User Filters (change 'Unknown')
Hi Team, I have a user filter at the top of my dashboard. The filter is referencing a column that has three values (Yes, No, and blank value). The blank value is actually empty not text saying blank value. The user filter provides a choice of Yes, No, and Unknown. How can I change the user filter from Unknown to say 'Not yet filled in', or Blank? The word Unknown is confusing and reduces the users trust in the data. Thanks Steve
Real Time Information
In Zoho Analytics its posibble to do it a dashboard to show information en real time?
USE SINTAXIS FOR != BETWEEN
HOW CAN I USE, DIFFERENT AND BETWEEN TOGETHER sum(if(cia_id = 30 AND CTA in ( 5401 , 5402 , 5440 ) AND SSSCTA != BETWEEN 900 AND 1099, debe01 + haber01, 0)) as ebitda, Detalles del error: El análisis de la consulta SQL falló. Compruebe la sintaxis SQL. Algunos consejos: Parse error at line 37, column 36. Encountered: BETWEEN
Graficación
Buenos días, todos los días hago gráficos en diferentes estudios realizados por la compañía, muchas veces estos gráficos son idénticos a otros en su creación pero están filtrados por diferentes atributos, ¿hay alguna forma de copiar un gráfico o duplicarlo para cambiar el atributo? del filtro y guardarlo con otro nombre? esto para no estar repitiendo toda la tarea en la elaboración del gráfico
Ask the Experts #3: Five hours live Q&A session with Zoho Analytics product experts
Hello all, Thanks for interactive Ask the Experts #2. We're hosting third Ask the Experts session this week. We're going live on 26th November 2019 (Tuesday) at 5am Pacific Time for five hours straight to address all your questions and get more feedback. Here is the list of experienced panellist for this session. Start posting your questions right away in the comments section.
Different Widget Shapes
A different shape for widgets to make dashboard more attractive eg. Circle - shaped widget.
Create a Menu in Long Dashboards
Hi, Kindly find a way to help users create a menu-like feature; where charts and data is displayed based on an item clicked. For example, I click the Name Sales figures; all sales charts drop down. I click the name Accounts, all accounts charts drop down and sales charts disappear. And an option for all charts to appear.
Add A dial on Pie Chart
Hello Guys, I am super new in ZOHO analytics. I want to add a dial visual on Pie chart. How can I add a dial ? If there is any solution, then please share with me. I want this type of Dial on Pie Chart. Thank You !
if Function for setting a Status with 1
Hello I have in the ZOHO CRM a status with different names ( "A - Lead Nurturing" or "Lead Nurturing beendet"). Now I wanna make a dashboard to know, how many leads have the status "A - Lead Nurturing" or "Lead Nurturing beendet". I need the formula in a pivot table, to write in the line, if the status is "A - Lead Nurturing" a number 1. If in Column "Status" is "A - Lead Nurturing" write in new cell "1" Thanks for help.
Email Address in Query Table
I have a table in Zoho Analytics with the Primary Contact's Email Address as one of the fields. I get an error when attempting to change that column's data type to "E-mail"...the error I have also attempted to change my query to concatenate the field into a "mailto:" link using the URL data type. However, the "mailto:me@gmail.com" URL directs me to the gmail.com website instead of my local default email application. All I'm looking for is a query table with a list of email addresses that are hyperlinked
Dashboards with UI buttons
are we able to create dashboards with buttons, like Push buttons, Radio buttons, etc?
Pivot table column
I can create tables with three columns. Is it possible to place the second column below the first one and not next to it (as in xls)
Show only before today
I have a widget that counts rows of data. I want to have a filter based upon a status and also a date filter that will only show data from before Today. These are filters on the widget. Is this possible? I can add the date filter but can't see something that gives the option of less than today. Thanks Steve
How can I display the last date time the data was imported
I would like to have a widget on the dashboard that displays the last time the data was updated or imported. I am running on-premise and have a scheduled import to run every hour. I could create a formula column in my data table and have it update to something like Now() to calculate the date and time the data was updated. But this actually refreshes on the widget to display Now. Let's say the import engine stopped for a few hours or days, the widget should pick up the last time the data was updated
Bar with line sort on Y-value descesding and line as a % sum of running total (Pareto)
When i go from bar chart to Combo chart i cant sort on Y-value descesding, but only on x axis. Is there a way to change this? Also i add the line as a sum running total - but can i do this as a running total % ?
Error Query
I need to calculate aggregate columns but not add them are independent calculations but whitin the same colum (sum(if(CTA IN ( 5405 , 5408 , 5409 , 5495 , 5496 ), debe01, 0)) + sum(if(CTA IN ( 5405 , 5408 , 5409 , 5495 , 5496 ), haber01, 0)) + (sum(if(cia_id = 66 AND (CTA IN ( 5410 , 5412 )) AND (SCTA = 10), debe01, 0))) + (sum(if(cia_id = 66 AND (CTA IN ( 5410 , 5412 )) AND (SCTA = 10), haber01, 0)))) (sum(if(CTA IN ( 5405 , 5408 , 5409 , 5495 , 5496
Add option to select all modules and fields when importing data
When you want to add all modules and fields it takes a lot of manual clicking to add everything depending on different data sources. The example below if for Zoho Finance which involves a lot of modules and fields. Please consider adding a checkbox or some other way off selecting all modules and fields at once. Best regards, Mladen Svraka Zoho Consultant and Authorized Partner www.mladen-svraka.hr
Best Dashboard
in zoho analytics it is possible to make this type of bullet and line graphics. Attached image...
New Features rolled out on Nov 8, 2019
More Authentication Types for Web Import Zoho Analytics now extends to support the following Authentication types for importing data from Web URLs. AWS signature Digest Authentication Hawk Authentication For URL authenticated using OAuth 2 Authentication, you can now specify the Grant Type . Groups UI Revamped We have completely changed the Create Group and Manage Groups user interface for enhanced user experience. Now Manage Groups is also available as part of Workspace Settings for
Can't find pivot chart option
Hi, where in the options can I create a pivot chart from an existing pivot table? I've searched the documentation but seems that the info is from an older version. Thanks
Teamwork Integration requests.
Hi, Is is possible to have the IncludeProjectOwner field changed from False to True on your standard integrations so the project owner will appear in the data please? Can you also please add to your standard API a call to retrieve the project updates from API? /projects/{projId}/updates.json https://developer.teamwork.com/projects/reference/project-updates/get-projects-projid-updates-json Many Thanks
Allow us to Embed KPI Widgets on my website
I am embedding reports directly on my website to create an admin analytics page which is awesome... but it is very difficult to show KPI widgets on my site. I tried creating a dashboard of KPIs and then embed the dashboard, but I can't get it to look the way I want. Can we get a way to embed KPI widgets like we can embed reports?
New Features rolled out on Sep 13, 2019
Introducing Geo Heat Map Zoho Analytics now provides a new geo chart type: Geo Heat Map chart. This can be used to display data in a geo-map, color-coded based on the density of points in a particular area. Geo Heat Maps makes it easier to identify spatial patterns in geographic data. This map can be used when you want to draw attention to the pattern of occurrence, for example, region with most deforestation and climatic changes, density of traffic by location, region with most sales, etc.
Move from Analytics Plus to Zoho Analytics
Hello, We have a license of Analytics plus with a lot of custom graphics and data imported from our ERP. Is there any easy way to migrate the information to Zoho Analytics? we don't want to create everything from scratch. Also, what is the IP range that we have to give permission so Zoho Analytics can see our database? Regards
LEFT JOIN not working on Query tables
Say I have DAILY_SALES and DAILY_INVENTORY data tables. If I use LEFT JOIN on both tables (for SSR measurement) only with <=> operator and group-by, the result is correct. If I have sales data but not inventory on certain date, it will return NULL. However, if I have DAILY_SALES_SUMMARY (query table of DAILY_SALES) and DAILY_INVENTORY_SUMMARY (query table of DAILY_INVETORY) then I make another query table say SSR2 querying both query tables, with the same method using LEFT JOIN and <=> operator,
Amazon sales data
Relational reports from disparate sources: Business Use case 1) The reports on amazon associates affiliate site do not provide an amazon Seller Order ID: # XXX-XXXXXXX-XXXXXXX 2) The amazon associates affiliate reports do provide a time/date stamp for when the order was placed. 3) the amazon associates affiliate report contains a sales order time stamp for the conversion: Date YYYY-MM-DD HH:MM:SS 4) The amazon associates affiliate report and the amazon seller central Sales order data contain
Hours & Minutes difference between 2 dates is not correct
End Date is 03-06-2011 05:30:00 PM Start Date is 03-06-2011 08:47:11 AM Formula that i'm using (saw on the forum board) is ((("Ready for Dispatch"-"Correct Data/CSV Received Time") / (1000 * 60 * 60))) The result i'm getting is 0.0245247.... Whereas it should be 08:43 in HH:mm format
Required date format for Zoho import over API
For A client we have build an API connection to ZOHO. Therefore we use: ZohoReportPHPClient Importing, updating etc works fine. But we have only one strange issue with the some date fields. We are offering the date like this: 31-03-2011 But then it's converted to this: 03-07-2013 This only happens when we use the API, when importing the same csv file manually we don't have the issue. Is there any specific date format that is expected when importing with the api? While writing this issue I see that
Chart Font size increase
Would it be possible to use a large font size on charts greater than 18px and the ability to use other methods of font size like pt or em - I use these dashboards on large screens to be displayed in an office and it is hard to read the text. up to 5em is required
Arrangement of selected items in legend
It could be very useful if the selected items in a legend are moved to the top of the legend in any chart view. In simple words, the legend must be sorted in real-time, with the selected items first, followed by the unselected ones. This would be extremely useful when we would have to share screenshots of reports in a chat group or a post. There might be a lot of items in the legend and the user might not be able to fit everything in the available column height, which can be mitigated to an extent
COLUMNS ADDED
ADD COLUMNS ADDED WITH THE SUM AGREGATION FUNCTION WITH UNIQUE WHERE CRITERIA FOR EACH OF THE AGGREGATED COLUMNS HOW I DO IN A QUERY
add column added
add columns added with the sum aggregation function with unique where criteria for each of the aggregated columns
as I do in a query
Next Page