topic Re: Aggregation with minimum in App Development

Aggregation with minimum

sowmyapai26 — Mon, 31 May 2021 02:05:30 GMT

I have a straight table with around 10 dimensions. I want to display 1 record with the min(value) based on a ID. Please help me to display just one record with minimum value as this has been a challenge rather than finding the min value itself.

Re: Aggregation with minimum

kaushiknsolanki — Mon, 31 May 2021 06:00:23 GMT

Hi,

Can you share your expected output.

Let us know how you want that to be seen in the table.

Re: Aggregation with minimum

sowmyapai26 — Mon, 31 May 2021 06:36:06 GMT

Thanks for the reply.

I have attached( a picture )of the sample data that I have created and highlighted in yellow the kind of output I am looking for. I want the minimum sales to be displayed along with the other dimensions in a straight table. Note that there can be duplicate records signifying the multiple sales . Any help is highly appreciated.

Thank you,

Sowmya

Re: Aggregation with minimum

kaushiknsolanki — Mon, 31 May 2021 07:06:11 GMT

Hi Sowmya,

In your example, you are showing only one line item in the chart. So just confirming is you want to have only one line in chart, which shows sales for the minimum year?

Re: Aggregation with minimum

sowmyapai26 — Mon, 31 May 2021 07:13:18 GMT

Yes I want only 1 line item and it should show the minimum sales Amount based on the model.

Re: Aggregation with minimum

kaushiknsolanki — Mon, 31 May 2021 07:27:01 GMT

Try this.

Create a new table with all dimensions and use the below expression to get minimum sales for the Model.

Sum({<Model = {"=Rank(Sum(Sales)*-1) = 1"}>}Sales)

Re: Aggregation with minimum

sowmyapai26 — Mon, 31 May 2021 07:36:30 GMT

Thanks for the reply. To complicate the query further if I need to find the min sales for a particular Make and model as well?