Help with KPI Widget please
Hi, I have a KPI Widget that is calculating the Avg of an Invoice amount. I am grouping by month. What my objective is to do, is to calculate the average monthly total by month. Example: If the date picker is showing this year and say 7 months have passed. I am wanting to calculate the average amount invoiced per month. (Add up the total of each month for the seven months, to get a total YTD, and then divide by the number of months (7), to get the average). This does not seem to calculate correctly,
New Features rolled out on Feb 28, 2020
Advanced Analytics for Site24x7 Advanced Analytics for Site24x7 helps to improve your service/platform availability & quality with meaningful insights on outages, alarms, monitors, and infrastructure. You can easily track the outages by analyzing the key metrics such as downtime count, duration of outage, frequency, and more across locations. This helps in identifying the root cause of downtime and take appropriate steps to maximize website, application and server performance and availability. The
ZOHO Analytics Case (Current Status of New Coronavirus Infections)
Current status of new coronavirus infections [Domestic cases (excluding those returning from charter flights)] I made it with ZOHO Analytics This is an example of how you can do this with ZOHO Analytics First of all, please click below. You can do this. Current status of new coronavirus infections [Domestic cases (excluding those returning from charter flights)] Creation time is only 15 minutes The data is not accurate because it is intended to introduce what ZOHO Analytics can do. Therefore, copying
New Features rolled out on Feb 20, 2020
Support for Amazon S3 Amazon S3 is the latest entrant being added to the list of Cloud Storages/Drives supported by Zoho Analytics. You can now analyze data from files stored in Amazon S3 buckets, using Zoho Analytics. Click here to learn how to analyze the data stored in Amazon S3. White Label Settings Page Revamped with More Customization Options! The White Label Settings Page has been revamped with a lot of additional features and enhanced usability. The new UI is divided into Settings and Administrative
Resource Utilization Report
I'm trying to build a report drawing from synced Projects data that will show planned resource utilization across multiple users/projects, by summing all their planned work hours for all their tasks by month. I'm able to find fields for budget hours and users, but I can't find a field that shows the time element of the table. I've tried duration and start date, but start date only shows time in the month it starts and duration doesn't offer the necessary options. For example:
Empty but successful XML feed over https gives error
I’m testing a data import to Zoho Analytics using Feed/XML data fetch from an URL with https. I have tested successfully the following request with CURL command line, it gives the XML response, given that I had CA certificate installed on my local Windows. There is no other explicit authentication method required. curl --cacert ca-bundle.crt -X POST -d dataname=xxxx -d key=xxxx -d token=xxxx -d table=orders -d column=closed -d value_min=2020-02-19%2000:00:00 -d value_max=2020-02-19%2023:59:59 -d
Shared Dashboard Not Displaying to the User
Hi I have a paid subscription for the Zoho Analytics. I have created several dashboards and shared with several users before without any issues. Today I created a dashboard, and shared it with 2 new users who I bought subscription for. For some reason, both the users are not seeing the shared dashboard. I have tried deactivating, reactivating, revoking access and again giving access. Nothing seems to work. Dont know what to do as the other shared dashboards are working perfectly fine and are being
How do I remove or edit custom ranges on a slider?
I have added some ranges to a slider, but have realised that I either made a mistake or want to edit what I created. I do not see how I can do this. I can add a new one and deselect the incorrect one, but would be nice to keep the area clean and tidy and not have non useful options. Thanks Steve
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
Ask the Experts #6: Five hours live Q&A session with Zoho Analytics product experts
Hello everyone! We're all set to host our second community event in 2020 - Ask the Experts #6 on 19th February between 05:00 AM - 10:00 AM PST. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar. This Q&A discussion happens right here on the online community forum. To participate, post your questions
Embending API problem
We're having an issue with the underlying data, We're using the embedurl from de api indicating the underlying data permission to true & the columns that we want to show. The UD was previously showing on the portal where we embed the url. We don't know if some of the documentation regarding the API changed recently. I hope you can point us what we are doing wrong. Just to reiterate this was already working before today
Databridge
I currently have the Databridge downloaded for a local database. Whenever I update that database, does the databridge automatically update it in Zoho. Or would I have to constantly re-import?
Images in ToolTip
Is it possible to show an image when rolling over a dataset? Basically I have my chart showing data (impressions) by creative. I want to be able to rollover the creative name on the axis and have it show an image of the creative vs. just having the name there. Or I'd even like to have it show the image in the tooltip along with the other data that I've placed there. Is this something that is possible or something you can add in to your roadmap? Thanks, Jamie
Query Table does not update with new data in dashboard
Hello, I'm using the On-Premises version of Zoho. I create two Query Tables that gets updated each week. Both of them are not refreshed automatically with the new data in the dashboard. When i select the query, the data shows the previous week, and when I go to "Edit Design" and "Execute Query" I see the updated data. Please see sample query below: SELECT "Week", "Actual2019", "Actual2020" FROM "SalesPerformance" WHERE "Week" in ( SELECT MAX("Week") FROM "Calculations" ) Am I missing a step?
How to create Pareto Chart like this
I try to create a chart like this image: The Acc axis is "Running Total", but show as "%Accumulate". This is what I can do. My problem is : 1. I can not sort bar chart from Max to Min (Desc.) while line chart is sorted by Min to Max. 2. I can use "District Count - Running Total" for Acc. But it cannot show as %Accumulate. Do you have any idea for this case ?
Renaming Data Sources
Hi Please see attached, I have 2 Xero data sources but I cannot see where I edit the names so I can distiguish one from the other in the dashboard and the reports. Please help Thanks Dave
How to get multiple sheet in a single excel file
Hi, The reports are created in Zoho Analytics I want to consolidate and bring them in one single excel file. My team requires such report daily and same should be scheduled using scheduler. Help me to solve this problem
Color Coded Map of Territories
How can I make a map where the States are color coded to the CRM Territories?
Date Format Doesn't Convert
I'm importing data from Google Sheets I'm trying to change the date format of the "date" columns to mm/dd/yyyy. In my original Google Sheet, the format is mm/dd/yyyy. The initial date format in Zoho is 17 Apr 2017 00:00:00. When I change the Format of Date Columns to mm/dd/yyyy, my date column in the table preview is then changed to a Plain Text data type. If I change the data type back to Date and then create the source, I get errors on the entire Date column: "RESET : Invalid Date value." Is
Sending repost by email FROM the creator of the report
Hey, we have several reports that we would like to send periodically via email. I've set up an Email Schedule but the sender of those emails is either me (as the admin) or notifications@zohoanalytics.com. The user who created the report would like it to be send on his behalf, so he edited the Email Schedule and set his email address (and of course saved!). The email is still being sent on my behalf, and I don't even see the email of the user who created the report. How can we solve this? M.
Importing to same table with differing data sequencing?
Ok, this might be a simple question, but say I’ve created a Table of Monthly Sales (columns) by Customer number (rows). If I have the same 50 customers for a while, so 50 rows, but then I have an import with only 48 customers, or 48 rows, how or will Analytics pick up and place the sales data in the proper customers row and place a 0 in the row(s) where no sales data is for that particular month? If it didn’t then the sales data would be placed in the wrong customer numbers.
Pulling in Attendance Information
I'm trying to pull in daily attendance hours from Zoho People into Analytics but it doesn't seem to allow for that dataset? I'm working on a dashboard that will allow me to compare time logged from tickets and projects to an employee's actual attendance time. Thanks, Scott
Ask the Experts #5: Five hours live Q&A session with Zoho Analytics product experts
Hello everyone! Hope you all had a great start in 2020. We're excited to host our first community event for the year Ask the Experts #5 on 22nd January between 05:00 AM - 10:00 AM PST. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar.
How to get the first result of rows with duplicate dates?
Hi, I have a table that contains the following fields: An ID An event A date-time for each event It looks like this: ID Event Event Date 1122334 Event 1 2016-10-01 10:00:00 1122334 Event 2 2016-10-01 10:00:00 1122335 Event 1 2018-06-23 11:43:22 1122336 Event 2 2019-02-02 08:04:13 1122336 Event 1 2019-02-03 06:07:17 1122336 Event 2 2019-02-06 13:37:44 My goal is to find the first event for a given ID, based on the date so that I have a list of unique IDs and their corresponding events and dates like
New Features rolled out on Jan 31, 2020
New Data Connectors We're happy to announce two new Advanced Analytics connectors--for LinkedIn Ads and Eventbrite--powered by Zoho Analytics. Advanced Analytics for LinkedIn Ads Advanced Analytics for LinkedIn Ads, enables you to visually analyze your marketing Ad campaigns, measure the outcomes, and derive actionable insights in minutes. Quickly analyze key performance metrics like traffic, CTR, CPC, CPM, conversion rate, and much more. Apart from analyzing your LinkedIn Ad campaigns, you can
How to input Values from 2 different tables on Y Axis & Generic Date on X Axis
I managed to feed values from 2 different tables on Y axis. But now I need to feed a Generic Date (Month/Year) on X axis. Im trying to make a Chart like: Receipts x Expenses Y (2 Bars) Time X Anyone know how can I do it ? If I insert date from one of the 2 tables (receipts or expenses) it doesn't load the chart data. Tks
Linking table from Zoho Reports to Excel
Hello, I would link to be able to have a worksheet in excel that gets automatically updated when there are changes in a Zoho reports table. I believe the Get external data option in excel should be able to do this, but I am unsure how to set it up to work with a specific table in Zoho. Any help with this would be appreciated.
New Features rolled out on Jan 20, 2020
Happy New Year! Zoho Analytics welcomes 2020 with some cool new options. Embed / Publish UI Revamped with Lot More Options! The Embed / Publish URL dialog has been revamped for better usability and has also introduced a good set of additional functionalities. The new UI captures the following: Embed and Publish options merged in a single screen Access with Login, Access without Login, and Access within Organization / External Users permission controls in the same dialog Status of the already published
Report of the Week - Geo Heat Maps
Geo Heat Maps can be used to display data on a geographical map, with color codes based on the density of points in a particular area. Using this map: You can easily identify spatial patterns in geographic data. You can indicate the pattern of occurrence, for example, regions with most deforestation and climatic changes, density of traffic by location, regions with very high / very low sales, regions with high magnitude / high frequency earthquakes, high rainfall precipitation regions, regions with
Nested Queries Issue in Query Table
I'am facing issue with nested queries , even after simplification of nested sub queries ,its not working ,please help solve this issue.
Elapsed & total business days
Hello - I'm building a sales dashboard from a data set comprised of invoice lines. Columns include things like date, invoice#, customer, sku, quantity, price, invoice_total, & customer_address. My dashboard shows stats for the current month like MTD revenue and number of unique customers. I'd like to have a dial widget that shows how many business days have elapsed in the current month and how many total business days we have in the current month. To try to solve this I've created four formula
Pivot table based in other pivot table
Dear Zoho Team Is it possible to edit one pivot table bases in other pivot table? Is it possible convert one pivot table in one chart view?
Mobile Dashboards
Hi, Dashboards in mobile are not very responsive. For example its hard to make scroll down/up , left/right. Wish is the best practice to develope a dashboard for mobile? Thanks
Data with different paths
I'm trying to cross invoice and billing data in Ozho Analytics, when I try to do this the message I get is that I can't cross data with different locations, there is a way to have on the same chart two information that I have already prepared and just want to see both in one only cross chart?
Free webinar: Top 7 BI trends disrupting the analytics landscape in 2020
Hello, The penchant for making analytics and insights available for all business functions is picking up steam in disrupting the BI landscape. This phenomenon is driving BI platforms to further simplify the diversity in analysing data across platforms. At the core of it lies AI, revolutionising the way businesses operate today. Join us for the free webinar to learn about the 7 BI trends disrupting the analytics landscape to prepare your business for 2020! Register now!
How to link Zoho CRM to Zoho Analytics
Hello Have an issue were I’m trying to connect my Zoho CRM to Zoho Analytics. Have built some dashboards for a client and I cannot figure out why I can’t link the two. thank you Alan
Countif not as aggregate column
Hi Is there a way I can achieve something similar as =(COUNTIF($B$1:$B1,$B1)=1)+0 as a formula column in my table? Where B is the column which contains the values, so it puts a '1' in the first record found and '0' in the others. Thanks
Nested If
Simply trying to add a formula column but something is wrong with my formula, anyone have any insight? =IF("Company Number"='WE1','Honda', IF("Company Number"='WE2','Chrysler', IF("Company Number"='WE3','Ford', IF("Company Number"='WE4','Chevy',"All Star")))) Thank you!
Filter Tabular View on Dashboard
I have a tabular view setup with a desired filter. When I add the tabular view to a dashboard I cannot find any way to apply that filter to the tabular view on the dashboard. How can I apply the desired tabular view filter when it's on a dashboard?
SQL Query for Point of Sale Data
Hi There, Just need some help formulating an SQL Query for our Point of Sale Data. I have attached a sample set of what the format is like. We are wanting to do the analysis on Transactions that contain "X" Product. That product for this instance being "BYO Party (8 kids)" Each item in the transaction is separated on individual lines. Each Receipt Number is unique to the POS and Each POS number is unique. The problem Is that the POS generates sequential receipt numbers for each POS so we have duplicate
Next Page