Hi all, I have a Dashboard where the lines rarely occur twice, but if they do the user should know about it. Therefore, I need the dashboard to be able to highlight duplicate fields. I cannot figure out how to set the filter values in the dashboard to create this highlight. The dashboard I have is…

Conceptually, what I envision is some sort of “second pass” over the original dataset. You might be able to accomplish this by using a subquery as your first pull of data encapsulated by a top level query. In the top level query, you would have the subquery results available and could perform a calc…

In the BAQ, make a sub-query that is essentially the main query, but has a calc field with a COUNT() to count the number of lines. Then in the Dashboard use a row rule to hightlight any row who’s count value is > 1.

Also, Don’t know what it would do to performance. But if you make every field of the the top level of the BAQ as ‘Group By’, you’d never get any repeats This is only if you just don’t want to see them. If you need to find them to take some action then, this ain’t for you.

If you a calculated field that is simply 1, then do a sum(calculated field) over (partition by x) (syntax might be wrong, but you get the point) with x probably being another calculated field where you concatenate the order number, line, the sum for those lines would be NOT 1. So you could add yo…

[image] ckrusen: Also, Don’t know what it would do to performance. But if you make every field of the the top level of the BAQ as ‘Group By’, you’d never get any repeats He’s looking for almost the same. The row will have different bin locations.

This is good and then you can add your calc field with this kind of query. I would investigate why the doubles are occurring? Is it a join issue or are there really multiple items. I think the group by would not be a huge performance hit.

[image] knash: Is it a join issue or are there really multiple items. multiple bin locations.

Another option would be to concatenate all the bins, and return it as a single field [image] BAQ Concatenate Rows Columns to Field ERP 10 I am trying to concatenate multiple rows to a single field in a query and am wondering h…

Hey, I have a question quite similar. If parts are repeatable with different suppliers then how we can highlight them in the Epicor dashboard?

Make a calculated field that counts the duplicates (using whatever rules you make up) and highlight rows with the count greater that 1. Calculated field count(1) over (partition by table.company, table.partnumber, table.whateverOtherFieldsYouWantToPartitionBy) Then set up view rules in your dashb…

Highlight duplicate value in Dashboard

Epicor ERP 10

ckrusen (Calvin Krusen) September 21, 2018, 5:38pm 9

Another option would be to concatenate all the bins, and return it as a single field

Topic		Replies	Views
Find Duplicate Values in Dashboard Epicor ERP 10 e10	2	2404	February 19, 2020
A way to Highlight duplicate data in a dashboard Yahoo Archive	2	430	January 14, 2015
Display count of something on dashboard Epicor ERP 10 dashboard	2	1753	August 18, 2020
BAQ Calculated field for alternating colors in Dashboard Epicor ERP 10 baq , dashboard	6	2362	October 4, 2019
Use "Count" function while ignoring duplicates Epicor ERP 10	14	1243	September 27, 2018

Highlight duplicate value in Dashboard

Related topics