With layoff news all over the place, I thought I’d do little analysis on the layoff data. I spent around 30 minutes creating a simple Layoff Tracker Application using Zoho Creator & Zoho Analytics. Here is the application I ended up creating. The interesting part is, how this was done. Let me explain on how this was done.
To get started, I created a simple Zoho Creator application pasting the data from TechCrunch Layoff Tracker which took me couple of minutes to place the data into Zoho Creator’s database. To do some analysis, Zoho DB & Reports is the perfect tool. So I decided to connect Zoho Creator & Zoho DB.
Recently, we rolled out the first cut of our integration between Zoho Creator and Zoho DB & Reports. I used this feature to connect both these applications. I created a database in Zoho DB & Reports and linked it to the data form Zoho Creator App and set it up to frequently update itself every hour keeping Zoho Creator as the Master DB.
This way, Zoho Creator’s forms can be used to input the data directly
into the Zoho Creator database which is then synchronized withZoho DB & Reports.
Once I have the database synchronized, I then generated several reports
dragging and dropping columns based on the data in Zoho DB (which is
automatically fetched from Zoho Creator). Here are some of reports.
Layoffs By Date
Layoffs By Month & Location
Layoffs Trend
Using the ‘Publish’ option in Zoho DB and HTML View option in Zoho Creator, I embedded these reports back in Zoho Creator Application in another tab. This is the final app with Reports tab displaying reports from Zoho Analytics.
We have a more basic IT Layoff Tracker using Creator, for layoffs at technology companies.
We have a more basic IT Layoff Tracker using Creator, for layoffs at technology companies.
Good work. But, some of the entries seem to be duplicated with different dates.
Good work. But, some of the entries seem to be duplicated with different dates.
FYI none of the non-name columns sort properly. They all get sorted alphabetically instead of numerically (#, %) or by date. ("Date")
FYI none of the non-name columns sort properly. They all get sorted alphabetically instead of numerically (#, %) or by date. ("Date")
Yay, nice job. I have been following the integration with interest and look forward to the first public release of the next level of interaction between these two apps.The question I ask myself is how long would it have taken to develop this pretty simple app and the reports/graphs etc using traditional methods?;-) Keep on doing what you are doing!
Yay, nice job. I have been following the integration with interest and look forward to the first public release of the next level of interaction between these two apps.The question I ask myself is how long would it have taken to develop this pretty simple app and the reports/graphs etc using traditional methods?;-) Keep on doing what you are doing!