Aggregation Conflict

Q&A
, , , , ,
1

I intend to have this text in my QuickSight dashboard

image

But this is what I get instead:
image
Apparently, I had used this calculated field:

image

and a filter field:

image

Thus, it returns the highest downtime hours per row, and not per shift.

Is there a way I can achieve my goal in Amazon Quick, to filter the aggregation at ‘Shift’ Level, and not row level?

2

Hi @Sarmie and welcome back to the Quick Community!

I think to solve this problem, you will have to use a Level-Aware Calculation - Aggregation (LAC-A) function. With this approach, your formula will look something like this:

concat(
  shift,
  ' has the highest downtime of ',
  toString(round(sum({downtime_hours}, [{shift}]), 3)),
  ' hours'
)

Unsure if this will work properly in your environment, but I do think this is the right approach to solve your problem. For additional context, I would strongly recommend checking out this resource as it walks through Level-Aware Calculations (Level-Aware Calculations: Tips and Best Practices - Learn / Technical Articles - Amazon Quick Community).

3

Thank you, JacobR. The article was quite helpful! LAC-W worked well for me**.**