AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

An example of a Dashboard in Acumatica 6

March 14, 2017 by Tim Rodman

You can get very creative with Dashboards in Acumatica 6. There are a number of new widgets available. Here is an example of a Dashboard in Acumatica 6.

During one of my presentations at Acumatica Summit 2017, entitled Business Intelligence for Business Leaders, I showed an example of a Dashboard in Acumatica 6.

Click here for the slides and other information from that presentation.

In this post I’d like to walk through how the dashboard was built. This will require that we first create generic inquiries because generic inquiries are like the hub of a wheel (click here) and are needed for most of the Widgets that you put on a Dashboard. Then we’ll walk through adding Widgets to our Dashboard.

Note: I’ve covered Acumatica Dashboards before in this post so you might want to also check that out.

 

Overview

Before we dive in, let’s first take a look at the Dashboard that we want to create.

Dashboards in Acumatica are made up of Widgets.

There are 7 different Dashboard Widgets available in Acumatica 6:

  1. Chart
  2. Data Table
  3. Embedded Page
  4. Power BI Tile
  5. Scorecard KPI
  6. Trend Card KPI
  7. Wiki Page

The first widget in our dashboard is a Scorecard KPI widget and the second is a Trend Card KPI widget. They both respond to the business date so here are two different screenshots that show different results depending on the business date.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Next we have two Chart widgets. There are 7 different kinds of charts: Doughnut, Line, Column, Stacked Column, Bar, Stacked Bar, and Funnel.

Personally, I’m a fan of the Bar chart more than the Doughnut (or Pie) chart because it’s much easier for me to see which pieces are bigger and by how much. So, the next two Chart widgets are both Bar charts.

An example of a Dashboard in Acumatica 6

 

And don’t forget that you can drill into Bar charts by either clicking the title (eg. TOP 5 CUSTOMERS or TOP 5 PRODUCTS) or by hovering over one of the bars like in the screenshot below and clicking. In both cases you will be taken to the underlying generic inquiry, but in the case of clicking an individual bar, the generic inquiry will automatically be filtered based on the bar that you clicked on.

An example of a Dashboard in Acumatica 6

 

Next we have another Chart widget (this time a Line chart) and an Embedded Page widget. The Line Chart widget is showing the top two customers so it’s not two crowded. I really like the Embedded Page widget because there are lots of possibilities. On the one hand, it’s just a webpage within a webpage. On the other hand, you can get very creative with it. The example below is showing the Google Currency Converter on the Acumatica dashboard.

An example of a Dashboard in Acumatica 6

 

Here is another Embedded Page widget, but this time we’re looking at an Excel Online file. So, you can design a dashboard in Excel, then display it with Excel Online within an Acumatica dashboard using a secret URL trick (click here). You almost don’t even recognize that it’s Excel, except for the little Excel icon in the lower left-hand corner. I’ll show you how to build this Excel file example in a later post.

An example of a Dashboard in Acumatica 6

 

Next we have a Wiki Page widget. Wiki pages are great for documenting business process flows, like the example in this screenshot here.

An example of a Dashboard in Acumatica 6

 

Another Wiki Page widget here, this time it’s an image that uses clickable regions with HTML code using a technique that Doug Johnson blogged about a while back (click here).

An example of a Dashboard in Acumatica 6

 

And last, but certainly not least (you might even say that I saved the best for last), here are two Power BI Tile widgets that I added using the technique from an earlier blog post (click here).

An example of a Dashboard in Acumatica 6

 

Alright, now that we have an idea of what we want to create, let’s get into how to create this Dashboard with each of the widgets.

Brace yourself for a lot of screenshots.

 

Step 1: Building the Generic Inquiries

Most of the Acumatica Dashboard Widgets (five out of seven) are built on top of Generic Inquiries. So we really need to build some Generic Inquiries before we get into building Dashboard Widgets.

We are going to build four Generic Inquiries.

 

1. CurrentMonthSales

First, let’s build a Generic Inquiry called CurrentMonthSales which will be used by our Scorecard KPI widget. In order to build this generic inquiry, I populated the following data in the Generic Inquiry screen in Acumatica.

Each screenshot is showing you the data on each tab. There are multiple screenshots for the Relations tab on some of the generic inquiries because the bottom section changes depending on which row you have highlighted in the top section.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

2. CurrentMonthSalesComp

Second, let’s build a Generic Inquiry called CurrentMonthSalesComp which will be used by our Trend Card KPI widget.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

3. Invoiced Items

Third, let’s build a Generic Inquiry called Invoiced Items which will be used by our two Bar Chart widgets. This Generic Inquiry is actually already available in the SalesDemo company, but I’m going to show how to build it here anyways.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

4. InvoicesDashboard

Fourth, let’s build a Generic Inquiry called InvoicesDashboard which will be used by our Line Chart widget.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 2: Creating the Scorecard KPI Widget

Now that we have built our Generic Inquiries, we are ready to build our dashboard widgets based on those Generic Inquiries.

I’m starting with an empty Dashboard and adding to it.

The first thing that we need to do is click the DESIGN button. Then we can click the add a new widget hyperlink.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

From here, we can then add our Scorecard KPI widget. Make sure to choose the Current Month Sales generic inquiry that you created earlier in this post.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 3: Creating the Trend Card KPI Widget

Next let’s create our Trend Card KPI widget which will also be based on the Current Month Sales generic inquiry that we created earlier in this post.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 4: Creating the first Bar Chart Widget

Now let’s create our first Bar Chart Widget (there will be a second) using the Invoiced Items generic inquiry.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 5: Creating the second Bar Chart Widget

This is basically the same as the previous widget except that we are checking the Show Sum of Other Entries box in the last screenshot to demonstrate the widget’s ability to display the extra “everything else” bucket.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 6: Creating the Line Chart Widget

This time we’re creating a Line Chart widget and only showing the top two customers. Otherwise the chart would get really crowded.

The formula in the Color field in the last screenshot reads:
=IIf(Value=’USA Bartending School’,’blue’,’red’)

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 7: Creating the first Embedded Page Widget

Super simple here, but very powerful. All we are doing is displaying the Google currency converter inside a dashboard, but the result is pretty cool.

The url in the Source field in the last screenshot reads:
https://www.google.com/finance/converter?from=USD&to=EUR

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 8: Creating the second Embedded Page Widget

This is my favorite example of an Embedded Page Widget. This is an Excel file being displayed inside an Acumatica Dashboard.

This utilizes the technique outlined in this blog post:
http://www.augforums.com/excel-online-web-app-and-acumatica/

You can use the following url in the Source field in the last screenshot:

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 9: Creating the first Wiki Widget

Next we have two Wiki Widgets. First the one with lots of text. This utilizes one of the Wikis that is available in the SalesDemo company.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 10: Creating the second Wiki Widget

Now for the pretty one with pictures, also available in the SalesDemo company.

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

Step 11: Creating the Power BI Tile Widgets

You won’t be able to reproduce these because I blacked out my secret keys in the second screenshot.

But I’m just using the method outlined in this blog post:
http://www.augforums.com/power-bi-tile-dashboard-widget-in-acumatica-6/

An example of a Dashboard in Acumatica 6

An example of a Dashboard in Acumatica 6

 

In Conclusion

I probably should have done a video 🙂

It takes a lot longer to do, but I like doing the screenshots because it makes it easier for me to reference quickly later.

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Dashboards, Acumatica Drill Down, Acumatica Generic Inquiry, Acumatica Learning, Acumatica Summit 2017, Acumatica Training

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Amend a SO with a status of "Shipping"

    I would first try to use Automation steps and adding th...

    By Ryan Brown, 8 hours ago

  • RE: Timecard reports/queries

    @tricia-carlson Ah, good point. I think you'd need to m...

    By Tim Rodman, 15 hours ago

  • RE: Saving a GI as a table to use in a separate GI

    Using a Generic Inquiry in another Generic Inquiry isn'...

    By Tim Rodman, 15 hours ago

  • RE: Adding a TAB to the Stock Item for Customer Forecasting Info

    Hi @stacy-johnson, I think you’ll have better luc...

    By Tim Rodman, 15 hours ago

  • RE: How do you link a SO to a PO AFTER the PO is created?

    The link is stored on the Sales Order Line, so you have...

    By Tim Rodman, 15 hours ago

  • RE: Amend a SO with a status of "Shipping"

    I think @ryanxbyte might have done a customization to h...

    By Tim Rodman, 15 hours ago

  • RE: Acumatica version 2019R1: ERP instance, companies/tenants, branches

    You can do it by User, but not by Company as far as I k...

    By Tim Rodman, 15 hours ago

  • RE: Format of the financial period from the textbox.

    @nicksm I think you're on the right track with CInt, bu...

    By Tim Rodman, 15 hours ago

  • RE: Mass change for Invoice Template

    This looks slightly different than my screenshot: ...

    By Tim Rodman, 15 hours ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.