You are right, I forgot to give enough information for context.
The chart in the GIF is the new chart engine, but in my case this does not matter : basically it’s just a chart based on a table with mainly durations.
The app purpose is to track employee time, then to provide KPI based on the time they spent.
People work on projects, that are related to agencies, businesses, market types, and so on.
To do so, there are:
- Various tables :
Hours ==> Main Table
- Market Types
- and some other tables…
==> because I wanted to focus per “period of time” on Dashboard, I created trimesterCalendar, monthCalendar, weekCalendar…and linked the Hour Table to each of those.
The advantage I found with the new Chart engine, is to focus on one period of time. The limit, is that it applies to only one chart. So, by using this method + interactive mode, I can apply the same time filter to each view.
Because the purpose is to analyse time spent on various criterias, there always is a column in the table Hours that references to the other tables.
In the end, with the graph view I get a nice star picture
As you can see above, everything connects to the table Heure/Hours
But, nothing connect to each others (which is normal…)
- Dashboard view with:
- 1 bar chart specifically for agencies : legacy chart
- 3 bar chart for Hours Table : new charts
- galery views for each table that is related to the main table Hours
My point is:
If I select one of the items from the galery views (which purpose is, for memory, to filter datas on charts), the other galery views won’t be filtered by any domino’s effect.
…Which is what I would like to do.
For example, if I select one item from the “period of time” Table (in green in the picture), I would like to have the galery views based on the Agencies (brown in the picture) to shorten.
if I pick the January month, I would like to see only the agencies where time have been spent during January.
In the opposite way, if I pick the agency MONTPELLIER, and that people worked for this agency only in January and February, I don’t want to see March.
Said differently again: this is like building dependent drop-downs, but here I want to build dependent galery views
I don’t know if I’m very clear in my explanations, feel free to let me know if this is not clear enough