$ 163.62
| Lines of code | 6030 |
| Technical Name |
dashboard_widgets |
| License | See License tab |
| Website | https://www.odooinsights.com |
| Also available in version | v 13.0 v 10.0 v 12.0 v 15.0 v 11.0 |
| Lines of code | 6030 |
| Technical Name |
dashboard_widgets |
| License | See License tab |
| Website | https://www.odooinsights.com |
| Also available in version | v 13.0 v 10.0 v 12.0 v 15.0 v 11.0 |
Free online training at www.odooinsights.com
Free new templates added regularly
Sales Purchasing Inventory And more coming soon!Quickly and Easily add amazing and powerful dashboards from our library of dashboards. Once added they can be customised easily to suite our exact needs.
Create Powerful Dashboards
Gain comprehensive business insights through dynamic graphs, charts, KPI cards and more...
Create multiple dashboards
Powerful query editor
Charts including line, bar, pie,
radar
KPI Cards
Goals and forecasts
Flexible and configurable options
Updates
- 27 April 2022 - Allow dashboard parameters options to be filtered.
- 26 April 2022 - Allow dashboard parameters to be empty to not apply parameter.
- 24 April 2022 - Add pointer icon for values that can be drilled down into
- 16 July 2021 - Added SQL data source for dashboards (KPI Card and charts)
- 14 July 2021 - Allow dashboard tile names to be expressions like email templates eg. "Sales report for ${user.name}"
- 4 June 2021 - Add dashboard parameter option that can be python code
- 25 May 2021 - Add option financial year date range
- 18 March 2021 - Add option to duplicate dashboard as a copy or as a linked dashboard
- 17 March 2021 - Add additional date range types (Yesterday, Last week (Monday-Friday), Last week (Monday-Sunday), last week (Sunday-Saturday),
- 11 March 2021 - Allow filtering dashboards based on dashboard-wide parameters such as records, numbers or text
- 10 March 2021 - Add parameters to dashboard to allow all tiles in a dashboard to read common parameters. eg. change a parameter to change the entire dashboard
- 12 February 2021 - Enhanced record list dashboard to allow related fields and advanced python code to evaluate the value of columns
- 4 February 2021 - Add new example dashboards for sales in dashboard library
- 29 January 2021 - Use regex to format chart labels
- 29 January 2021 - Allow specifying per user goals
- 28 January 2021 - Add new date range type "This Month To Date Last Year"
- 28 January 2021 - Add new date range type "This Month Last Year"
- 26 November 2020 - Advanced python goal filtering to allow advanced python dashboards to apply specific goals for data based on data or current user
- 26 November 2020 - Advanced python goal filtering to allow advanced python dashboards to apply specific goals for data based on data or current user
- 20 November 2020 - Allow exporting dashboard to excel
- 9 October 2020 - Allow adding per user group filters for dashboards. eg. sales person can only see their own records, while manager can see all when looking at the same dashboard
- 9 October 2020 - Allow sending dashboard emails as the dashboard recipient
- 8 October 2020 - Allow dashboard to have a quick change date range to change for the whole dashboard at once
- 7 October 2020 - Allowed sub-dashboard drill-down actions
- 2 October 2020 - Additional dashboard templates added
- 1 October 2020 - Odoo v14 Version available
- 31 August 2020 - Created Dashboard template library (Sales, Purchasing, and Inventory)
- 25 August 2020 - Improve live preview dashboards
- 10 August 2020 - Improve scheduled emails for dashboards
- 10 August 2020 - Add new accumulation settings on charts
- 10 June 2020 - Add date filter type for 'Today' and 'Yesterday' for On/Not On/After/On or After/Before/On or Before
- 5 June 2020 - Add option to allow tiles to be scrollable when they take up more space then given (eg. for data tables to allow scrolling).
- 2 February 2020 - Allow drag & drop and resize of dashboards.
- 25 October 2019 - New dashboard type for 'Record List' to show a list of records from a query. Select columns, format data, column labels.
- 24 October 2019 - Improve dashboard configuration screen to make it easier to create and setup dashboard items.
- 23 October 2019 - Allow limiting results to top X results
- 15 October 2019 - Improvements for v13
- 2 October 2019 - Add in "Next x days/months/years date range options
- 1 October 2019 - Allow setting chart max/min axis and decimal precision on axis
- 17 September 2019 - Scheduled emails - Automatically email a copy of dashboards each day/week/month
- 13 September 2019 - Advanced line chart - Show average lines on one graph
- 12 September 2019 - Formatting - Allow a prefix such as $ to chart values
- 29 August 2019 - Advanced Goals - Allow goals to be prorated by current progress in goals. Eg. 30% though the goal period will show an expected target of 30% of the goal period
- 15 August 2019 - Tables - Allow showing tables of data
- 15 August 2019 - Advanced Tables - Allow python code to generate custom tables
- 1 August 2019 - Formatting - Use friendly scale values eg $1K, $1M, etc
- 17 July 2019 - KPI Card - Allow using a cached value for the dashboard that is refreshed daily for slow running queries
- 13 July 2019 - Advanced KPI Card - Allow KPI cards to be generated dynamically with python code entered into Odoo UI
- 3 July 2019 - Embedded content - Allow embedding HTML/URL content as a dashboard item
- 21 May 2019 - Dashboard display - Allow playing a sound (Buzzer, Cheer, or custom) when the dashboard value increases or decreases. Useful for TV dashboard displays for alerts, KPI goals
- 29 April 2019 - Graph - Add Pie/Radar graph types
- 23 March 2019 - KPI Card - Add forcast options to KPI cards
- 20 March 2019 - Dashboard Display - Allow tagging dashboard items to allow better organisation and re-using dashboard items on multiple screens
- 14 March 2019 - Query - Allow changing aggregation method (Odoo v12+) for sum, average, etc
- 8 March 2019 - Dashboard Display - Add live preview of dashboard items while editing
Dashboard Charts & Graphs
View your data in fresh and intuitive formats
Pie Chart
Drill-down: Click to open
data
Allow multiple grouping
of data
Radar Chart
Drill-down: Click to open
data
Allow multiple grouping
of data
Line Chart
Drill-down: Click to open
data
Allow multiple grouping
of data
Optional goal line that
varies with date
Advanced Line Chart
Drill-down: Click to open
data
Allow multiple grouping
of data
Optional goal line that
varies with date
Bar Chart
Drill-down: Click to open
data
Allow multiple grouping
of data
Optional goal that varies
with date
Stacked Bar Chart
Drill-down: Click to open
data
Stack bars and allow
extra bar for optional goal line
Allow multiple grouping
of data
Optional goal that varies
with date
Dashboard Parameters
Easily see a dashboard for a specific user, customer, sales team and more.
Date ranges: Today, this week, this month, last month, etc
Records: Choose any record type such as user, customer, sales team, warehouse, etc
Numbers: Allow filtering based on a number. eg. Only show sale orders over $X
Text: Allow filtering based on a text. eg. Only show sale orders with product names containing a word
KPI Cards
High level insights into business performance, forecasts and targets
Standard KPI Card
Drill-down: Click to open data
Easily set background color
Allow goals and forecasts
See goal and forecast variation
Configurable options
Advanced KPI Card
Drill-down: Click to open data for each query
Show result of two queries
Show result as a ratio of the result from two queries
Configurable options
Dashboard Tables & Lists
Clear detailed data at your finger tips
Record Lists
Drill-down: Click to open records
Filter records, sort data and set the max number of results
Select columns, label columns and specify value formats (eg. currency, date formats, rounding, etc)
Pivot Tables
Drill-down: Click to open data to see details
Allow multiple grouping
of data
Show the same data as the charts/graphs as a table for clear detailed view of data
Advanced: Use Python code to create powerful query table options
Simple. Drag & Drop Interface
Drag and Drop dashboard tiles to create your customised dashboard
Responsive layouts that let you set and resize tiles to ensure your dashboard stays beautiful.
Limitless potential to demonstrate your business analytics in a clear and professional manner.
Built for TV Displays
Auto refresh dashboards to keep the team informed
Standard KPI Card
Keep the team informed
Improve team moral
Unlimited TV displays
Auto-refresh displays
Keep up-to-date with scheduled emails
Send an email of your dashboards automatically
Automated Emails
Send dashboards easily
Snapshot data for your team
Configurable schedules
Unlimited email schedules
Creating A Dashboard
Create a new dashboard easily with powerful reporting features
Advanced query editor
Auto date ranges (eg. this month, this year, last month,
etc)
Group date fields by month, week, day
Measure query by result record count or a specific field
eg. invoice total
Allow group by two levels deep to create multi-series
graphs
Allow selecting a specific action to open data with when
clicked (eg. Open in kanban view)
Drill down into data
Drill down into any data through a chart or KPI card
Seamlessly navigate your data with dynamic click-through on all graph, chart and card types.
Explore your dashboard results by drilling down into data filtered by time period, category and other groupings of your choice.
Other Features
Query Editor
Advanced query editor
Auto date ranges (eg. this month, this year, last
month, etc)
Measure query by count or a specific field eg.
total
Allow group by two levels deep to create
multi-series graphs
Allow selecting a specific action to open data with
when clicked (eg. Open in kanban view)
Goal Editor
Allow goal to change with date (eg. Monthly
goal with seasonal variation or yearly goal for year on year growth goals)
For KPI cards a goal can be good when the value
is above or below the measured value
Dashboard Editor
Preview the dashboard item
Easily configure flexible and powerful
dashboard items
Add notes that are displayed on the dashboard
Add notes that are shown on the back-end only
Tutorials
Have suggestions, feedback or issues?
Purchased the app?
Issues - Issues will be addressed with the highest priority.
Suggestions - We love suggestions and will do our best to add your ideas to the road map.
Feedback - We welcome feedback so that we can continue to improve this app for our users.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. Icons made by Smashicons and Freepik from www.flaticon.com is licensed by CC 3.0 BY https://www.flaticon.com/authors/smashicons https://www.freepik.com/
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedThere are no ratings yet!
Can it run side by side with dashboard ninja?
Hi,
Can you confirm if your product can run without problem with dashboard ninja as I have this installed on my production .sh server.
Amin
Planned v15 Upgrade
Hello, are you planning to updgrade your app to v15 at some point this year?
Re: Planned v15 Upgrade
Hi,
We have a v15 beta ready. Let me see if it's ready to be released and we will out it up to the appstore asap
can i have a demo
Hi , can you share with me a demo link, i am the final step for purchasing ,
interested on community edition V13
please share that on my email
sales@qimamhd-tech.com
dose your module support odoo community V13
please confirm that is support community edition V13
Re: dose your module support odoo community V13
Yes we support community v13. Thanks for asking! Chris
A very powerfull and professional looking dashboard module with no limits?
I must admit that I first bought the module for the professionnal rendering of the differrents graph.
And when you start to use it you just start to see the powerfullness of the module and the deep thinking put into it.
Easy to use, intuitive, and if you want to go deeper you can even code some python computation?
The best money spent on odoo so far. Really. I'm even using these dashboard to make some specific request to track issue in my BOM, my stock.
(Ever wanted to detect some archived line in your BOM? 15 minutes and you got a dashbaord with the list and you can click on it to display an adhoc treeview! All with mouse and click...!)
Want to list all the product without a supplier ?
Will save me a lot of time!
Just fantastic so far
Re: A very powerfull and professional looking dashboard module with no limits?
Thank you very much for your review. We are very glad to hear you are enjoying the module and are finding it so helpful
Transpose table
Hi Chris,
Thanks for the quick response. I have one (actually two) more questions:
1. I have data stored in a table where for reporting purposes I have to transpose the table (rows->columns). Will this app let me do it?
2. And if not could I call a stored procedure and then use the returned dataset in a report?
Thanks
Re: Transpose table
Not sure exactly what you mean, for reports you can group by two dimensions which changes the row/columns of pivot table, etc. However using the OCA module bi_sql_editor will allow more flexibility creating a sql-view-based record type in Odoo that could be used like any other record type in Odoo but it would be based on sql. Feel free to contact me at chris at inspiredsoftware.com.au if you have any other questions, I would be happy to help. We have on the roadmap to allow using sql directly as the data source in the app, but the bi_sql_editor module fills that gap in an even nicer way. Chris
large tables
have you evaluated performance on tables with 10M+ records?
Re: large tables
Hi,
Thanks for a great question. We haven't however the module generates the data using standard Odoo api such as search, search_read, read_group, etc and adds in any domain filters, record limits, sort orders defined on each dashboard tile. I would expect the same kind of performance when generating the same kind of data in other areas of Odoo.
There is also a 'cache' feature that can be used on some of the dashboard tile types that will compute the value in a scheduled cron and keep the copy ready to display on a dashboard quickly. This may also be of use.
Additional Customization
Hello, can you do additional customization for this module?
can you provide us please with email address or skype contact so we can communicate better our requirements.
Thanks
Re: Additional Customization
Hi, we provide customisation options for the module. If you email me on chris @ inspiredsoftware.com.au and I would be happy to talk further about it.
Hi Sir I want to know if your dashboard module allow to check data from two modules, i mean something like ... How much sales amount i got from items sold from a vendor to know the the vendor is reporting me a profit ...
ty
Re:
Hi,
Thank you for your question. This one could be tricky depending on if you buy the same product from multiple suppliers. If you use 'Buy to order' this would be possible as there would be a link between which sale for which supplier.
If you buy to put into stock from multiple suppliers for the same product you wouldn't know which supplier's product each sale sold if each product has multiple suppliers.
In the simpler case that each product only had one supplier you could use either of the options below. Let me know if you have multiple suppliers for each product that you use and we could explore how to find the data you want in Odoo. If its there it can be reported on in one way or another.
Sales by the primary supplier (Ie. sales grouped by the first supplier listed on the product suppliers list)
- Add a custom field in studio or Odoo technical settings -> Models as a compute field for the first supplier listed on the product
- Create a dashboard tile for sale order lines, grouped by this new field for the first/primary supplier
Sales that have a specific supplier (ie. All sales for products that have ABC Supplier as a supplier listed on the products)
- Create a dashboard tile for sale order lines and filter on sale_order_line->product_id->seller_ids contains ABC Supplier
Hope this helps!
Interested
Hi, we are looking for sales reporting dashboards like sales per product category, margin per product category, sales and margin per customer, etc. Is it possible to build such reports with this module? Is it possible to test the module on a test server before we buy?
Thanks in advance! Georgi
Re: Interested
Hi Georgi,
Thank you very much for your question. I have listed the approach for each of these to build them in the dashboard app.
You can create dashboards based on any record in the system. Odoo has created a "Sale Report" record that helps summarise the information you are looking for. You can use this in our dashboard module to bring any of the information in any of the dashboard tile types and along side any other information in your system. There is also our free training videos at https://www.odooinsights.com/ that may help you further.
Sales per product category: Based on the sales report record type, measure untaxed total and group by product category
Margin per product category: Based on the sales report record type, measure margin and group by product category
Sales and margin per customer: Same as above but group by the customer instead of the product category