Max/Min of share across dates

[punitpopli]

Hi All,

I am having a below requirement in my project.

Requirement : To display max/ min of share for a particular product in all the weeks.

Share calculations : Share of a product among all the products and data is on Week level,this I am able to achieve it.

Now, I have to get max of share of a product across all the Week Ending dates

for eg : Max in my case it is 20.8 and min of share to be 18.6 in the sample data set attached.

Let me know if anyone had implemented the same.

Thanks,

Punit

[sunny_talwar]

Are you trying to achieve this in the script or the front end of the application??

[punitpopli]

Hi sunindia‌

I am trying to achieve this on front end

Thanks,

Punit

[sunny_talwar]

Don't know how your other expressions look, but you will need to apply something like this:

For Max: Max(TOTAL Aggr(yourExpressionForShare)

For Min:  Min(TOTAL Aggr(yourExpressionForShare)

If Share is directly a field from your table then you can try something simpler:

For Max: Max(TOTAL Share)

For Min: Min(TOTAL Share)

If either doesn't work, I would ask you to share a sample application.

Best,

Sunny

[anbu1984]

Check this app

[sunny_talwar]

anbu cheliyan‌ you might have forgot to attach the app bud.

[anbu1984]

Here is the app