Is there a way to capture quarterly sum of "goal" when looking at a quarter by week, drilled down to the goal holder on a running totals bar graph?
We want a cumulative running total on the main card, showing sales progress to goal throughout the months, which I have... But when I drill down to the salesperson responsible for the goal, I lose the goal because the data is not weekly, but monthly.
Wondering if anyone can help me create a BeastMode that will sum the goal data (given by Month) into quarterly total that can be associated to any given week?
Or do I need to look at this from another angle?
There are a couple ways this could be tackled depending on the structure of the data powering this card, but I will need some more detail around the card and data powering it. If each sales rep has their own associated goal data for a time period (day, month, quarter, etc), then a Beast Mode would most likely suffice.
Could you provide some more details around the structure of the data powering this card, and of the card itself, so we can find the best solution?
We've created a support case for you on this. You should be receiving an email from them asking for the necessary information. Your case number is 01693375.
I see that Support opened a case - which is nice - but I have the same question (rolling total) and am not sure how to get there.
I'll open a new Dojo question.