Grouping off detailed BAQ (REST / Dashboards)

Does this seem wrong to you?

Basic BAQ grouped by all fields.

I know the actual BAQ shows a lot of lines and it’s returning those lines. I was under the impression that you could have one BAQ and if you only called specific fields, like the Plant field, it would group off just that, regardless of the level of granularity displayed on the actual BAQ.

It’s like in a dashboard if you have ten fields around orders hidden and are only showing the company field. You wouldn’t expect the same company to repeat multiple times, but I’m seeing that in Kinetic dashboards as well as in the rest calls. Groups fine in classic.

I am trying to not manage multiple baq’s around the same data.

Single table BAQ with just a plant parameter.
image
image
image
image
image

Also, when a dashboard is being created, before publish “group by” is selected, then save is clicked, then deploy classic and kinetic.

Open the dashboard and no group by option. When you click and drag a field you get a “not allowed” (/) icon.

1 Like

Nope. The same BAQ is run in the background, and just returning specific columns doesn’t change the grouping.

1 Like

Is there a path to having one BAQ that can be called to get header or detail level information so multiple BAQ’s are not necessary or is it recommended to have one for each?

You may want to try using advanced groupings.

The grouping is done using the calculated fields with a value of one.
There are several ways to do advanced groupings, I have worked with advanced groupings.

When placed on the home page for example
you can filter it by placing a 1 on the filter you want

Here I grouped on the customer and product group combinations, filtered the results on Addison.

I should add that the query has a CTE subquery to hold the groupings.
This isn’t an error there is no link to the subquery Groupings

This is not an error - no table is listed, this query just holds some calculated values.


All of these have a value of one.

Here’s all of the details that are summed by group.

You would probably put a date filter on this - I did this in the Education Database
OrdersGrouped.baq (12.4 KB)

1 Like

Thanks Bruce! Hope all is well. That makes a lot of sense.