Share
Report
141Hi Team - I have a chart that I'd like to filter based on multiple conditions.
The chart will need to do the following:
- User selects a name in chart 1 (left Chart)
- Left chart populates with all Open/Filled/Vacant position
- Second chart (to the right) populates all locations based on Open/Filled/Vacant positions
- The chart filters when the user selects specific locations
- when the chart filters it shows the count by each location
- it shows the count by role type (open/filled/vacant)
Chart #1 is working correctly. I also I managed to get the chart to work when the user selects a location and the status of a role. However, I can't seem to get the chart to populate all information at once so the user can see, all their open/filled positions by location.
Here's the code: AddColumns(GroupBy(Filter(TechProdHCTracker,
Tech_Lead = CmdChart1.Selected.Result,
Country_Location = CmdLocations.Selected.Result,
Role_Status = CMDRoleStatus.Selected.Result),"field_13","InternationalChart"),
"MyIntlChartTotal",CountRows(InternationalChart))
How can I make the second chart populate with all locations and then filter it based on locations and Open/Filled roles?
Thank you,
Anna
All responses (
Answers (
