You’re offline. This is a read only version of the page.
36
Hi,
I've got a ListBox control (ListBoxCategory) and a drop-down control (DropdownEmployee). I would like my Line Cart to display information based on the employee you select in the drop-down list, and the categories you select in the list box.
Data source: CategoryTable
The ListBoxCategory's Items is set to 'CategoryTable', and the Value is set to 'Category' - it displays 'Lunch', 'Meetings', 'Work', 'Travel', and 'Breaks' (the values in the Category column)
Data source: EmployeeTable
The DropdownEmployee's Items is set to 'EmployeeTable', and the Value is set to 'Employee'.
The line chart's data source (EmployeeDetails) contains a 'Category', 'HoursSpent', 'Employee', and 'MonthYear' column. The MonthYear column contains dates formatted as text:
Data source: EmployeeDetails
The line chart should display data from the 'HoursSpent' column that corresponds to the selected employee (DropdownEmployee) and the selected category(s) (ListBoxCategory). For example, if you select 'Lunch' and 'Travel' in the ListBoxCategory, it should display the corresponding 'HoursSpent' value (Y-axis) and the MonthYear (X-axis) so that you can see one line that shows which months the HoursSpent for Lunch and another line that shows the HoursSpent for Travel.
Right now I have it set to:
Filter(EmployeeDetails,Employee=DropdownEmployee.Selected.Employee,CategoryValue=ListBoxCategory.SelectedItems.Category)
but this is not working.
Please help.
Share
Report
All responses (
Answers (
