- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Gauge chart: how to set min e max depending on cycle dimension
Hi, i've a total quantity of products i want to represent on a gauge chart depending on a cycle group:
- Agent
- Sales manager
- Area manager
I've tried to settle a MAX like this
=max(aggr(sum(QUANTITY),SALES_MANAGER)) but when a cycle my dimension on agent, it doesn't report their efforts in the right way.
The same for the MIN. Is anybody able to give me a suggestion about this.
Tks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
=Max(Aggr(Sum(Quantity),GetCurrentField("YourCyclicGroupName")))
Hope this helps,
Jason
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, I',ve made a mistake, this formula gives me a error of bad min or max in the gauge. It looks like it doesn't recognize the cycle group
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you be more specific? Or better still please post your app.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression to calculate quantity, is this:
sum({<FG_NRT={'N'}>} QUANTITY) where set analyis FG_NRT is only to extract consolidated value, in the min and max i have:
MIN= 0
MAX= max(aggr(sum({<FG_NRT={'N'}>} QUANTITY),GetCurrentField("Area Analisi")))
i've tried also changing Area Analisi in Area_Analisi but no success
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What value are you getting for Max and what do you expect? try removing current selections in your Aggr():
= max(aggr(sum({1<FG_NRT={'N'}>} QUANTITY),GetCurrentField("Area Analisi")))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Neither previous nor this, it seems that the only way to solve the error is to calculate aggr for all the members of my cycle group excluding the min (agent) and max (area manager) aggregation
=Max(aggr(sum({<FG_NRT={'N'}>} QUANTITY), Sales manager))
Tks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Seriously, if you post a sample application it is much easier for us to help you. I'm what you want can be achieved.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Give me more time to post the sample, i'm very interested to solve this problem in a smarter way. Tks