locked
Scorecard displaying minimum value of dimension X for each dimension Y RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    My scorecard should display profit (measure) for each sales agent (dimension)  in each region (dimension) .

    On the sales agent level I'd like to display the minimum region profit for that sales agent. How?

    (I've changed the KPI's target Calculation to be "Min of Children" but in the scorecards it does not show the min rather gives the whole profit for each agent).

    Your help appreciated.

    Namnami

    Sunday, March 5, 2017 12:26 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    I used  a hierarchy in the scorecard (agent>region). Then made 2 filters- Agent filter and Region filter. Passed value from Agent filter to Region filter and then passed value from region filter to the scorecard. 

    What made the trick was setting the agent dimension from an outside filter (requires dashboard).

    Now the total calculation displays "Min of Children" as specified in the KPI. 

    Namnami

    • Marked as answer by namnami Thursday, March 9, 2017 10:35 AM
    Thursday, March 9, 2017 10:35 AM