AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Dashboard...
Dashboard Parameter...
 
Notifications
Clear all

Questions Dashboard Parameters Aren't Filtering Data from Underlying GI

 
Acumatica Dashboards
Last Post by mcraig 3 years ago
4 Posts
4 Users
2 Reactions
2,181 Views
RSS
Aaron Newby
Posts: 2
 Aaron Newby
Topic starter
February 15, 2023 6:08 pm
(@anewby)
Active Member
Joined: 3 years ago

I have created a GI that exposes Gross Profit Margin % by using a weighted average formula and am now trying to expose this data via a KPI Meter Widget on my Sales Manager dashboard.

image

On the dashboard, I have a date range parameter set that controls and filters the data of each widget on the dashboard based on the date range input by the end user. However, for some reason, I cannot get the KPI meter widget to respond to the parameters I have set.

Regardless of the date range selected, the widget is only showing the data as exposed by the GI itself. The only thing I can think of is that the grouping on the GI is somehow preventing the parameters from taking effect.

I can add parameters to the GI itself to manipulate the data as I see fit (see screenshot below).

image
image

However, when I remove the parameters from the GI in order to allow the dashboard parameters to filter the data, the data result doesn't respond - it simply exposes whatever the GI shows.

image
image

For a little more background information, the GI is using grouping in order to accomplish a weighted average for calculating gross profit margin. Taking a standard average of GP % results in an inflated margin % result which doesn't my team accurate data. Happy to provide more details as needed. Thanks in advance for your help!.

 


Topic Tags
grouping Parameters Dashboard Generic Inquiry
3 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
February 15, 2023 7:08 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Did you map the dashboard parameters to the GI via the widget? 


Reply
Tim Rodman reacted
Tahir Siddiqui
Posts: 3
 Tahir Siddiqui
February 16, 2023 4:58 am
(@tahirsiddiqui)
New Member
Joined: 3 years ago

go to widget property ---then filter setting ---then define there see attachment 

image

 


Reply
mcraig
Posts: 65
 mcraig
February 16, 2023 1:32 pm
(@mcraig)
Estimable Member
Joined: 6 years ago

There have been a few posts on this problem.  Here is another one that may be related

Acumatica Dashboard Parameters • Acumatica Dashboards • Acumatica User Group Forums (augforums.com)


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Expand Collapse Button on Dashboard
    3 years ago
  • Single Column Chart
    3 years ago
  • Create Monthly P&L Summary for Past 12 Months and Previous 12 Month Periods
    4 years ago
  • Sharing personalized dashboard
    7 years ago
  • Parameters on Dashboards
    7 years ago
Topic Tags:  grouping (3) , Parameters (9) , Dashboard (9) , Generic Inquiry (41) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 21 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×