count distinct orders based on grid

[dzimmerman]

is there way to count the distinct value (lets say the order # field) and display it somewhere in my valence application..either on the grid or in a heading.

so a user will select a bunch of critiera and press the search button, a grid will display a bunch of records (orders with multiple line items). The user wants to see displayed somewhere the total # of orders based on their selection.(distinct orders)

would i have to create a custom program and pass that information back to an app variable and display it somewhere or is there an easier way of doing this.

[sean.lanktree]

The KPI widget may work for you. You would just have another data source behind it that you would also "Filter Widget" against when the user clicks the search button.

[dzimmerman]

thanks i will research that :)

[sean.lanktree]

You would likely want to wrap your grid and KPI widget in a "vertical container" utility widget. You can set a fixed height on the KPI and then allow the grid to take up the rest of the vertical space.

[dzimmerman]

this worked well thanks.