Solved: A running total in a dynamically filtered table - Page 2

Stouenborg · 09-19-2023 06:54 AM

Hi Everyone

I hope there is some help in this forum for an issue I have struggled with for a while. I have searched wide and near for answers without luck.

I have a table with time registrations from a group of employees. Each row contains the Employee (ref), Project (ref), WorkType (ref), and Duration (calculated by [EndTime]-[StartTime]).
Have a Dashboard view with the table of all the registrations, and reference views that allow me to select a project, work type, and/or employee. The registration table filters nicely depending on my selection in the three reference views. All Good.

Here is the problem: I need to calculate the Duration for the rows displayed in the Registration table and update it with the selected filtering.

How can I make this happen?

I have tried various solutions, but it always calculates the Duration for all rows, even the ones hidden by the filter.

I really hope you can help.

WillowMobileSys

@Stouenborg wrote:

There is, however, a need to filter on (up to) three different settings (Project, Employee, and WorkType). I'm not sure how to solve this using your idea. Can you elaborate?
The "Duration" is not a virtual column. It is a calculated value stored in a column.

Since you are filtering by 3 different categories - Project, Employee and WorkType - you wouldn't be able to obtain a single clear Total Dashboard amount from just a single Grouped Table View.

And there are several different permutations of filter selections. In this case, if it is critical to obtain a clear Total Duration value no matter how the data is filtered, then I would have to recommend the usage of a custom filtering panel with a Slice.

It is not too terribly hard to implement just extra steps. The idea is to create a Filter table with the 3 categories to filter by. Then a Filter Form is presented in the Dashboard. When the user saves the filter row, a Slice uses the row to filter the data. You are then free to include whatever visual components you wish to provide the resulting filtered data and totals.

View solution in original post