You’re offline. This is a read only version of the page.
Hi Experts,
I have the below code in a text label to calculate all entries logged with certain criteria.
Share
ReportCountRows(
Filter(QualityPortal,
'Business Unit' = 'Dropdown-BusinessUnit_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessUnit_2'.Selected.Value),
Classification = 'Dropdown-Classification_2'.Selected.Value || "Please select an option"=('Dropdown-Classification_2'.Selected.Value),
Status = 'Dropdown-Status_2'.Selected.Value || "Please select an option"=('Dropdown-Status_2'.Selected.Value),
Function ='Dropdown-SourceFunction_2'.Selected.Result || "Please select an option"=('Dropdown-SourceFunction_2'.Selected.Result),
'Cause Category' = 'Dropdown-CauseCategory_2'.Selected.Title || "Please select an option"=('Dropdown-CauseCategory_2'.Selected.Title),
Source = 'Dropdown-Source_2'.Selected.Value || "Please select an option"=('Dropdown-Source_2'.Selected.Value),
'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessChange_2'.Selected.Value)
)
)
In my sharepoint list, the Title column shows the date and time a user creates an entry in the sharepoint list (see below)
Is there a way that I can adapt my code at the top so that I can filter to show the total results during a time period either a day, a week, a month etc. My thoughts are to have a start date choice and an end date choice so that the code filters based on the criteria between those 2 dates?
Thanks in advance!
Hi @Dave-ITMan,
Could you please tell me that how you configure this start date choice and an end date choice?
Generally, we could use the following formula to filter records during a time period:
All responses (
Answers (
Filter(QualityPortal, StartDate.SelectedDate <=DateTimeValue(Title)<=EndDate.SelectedDate )
Note that only date value could be compared with.
610
