Please help to make a slice that show the data fallen within the current month
Start Date End Date Utilization Percentage
01-Feb-2022 28-Feb-2022 20
3-Jan-2022 31-Dec-2022 40
16-Feb-2022 15-Feb-2023 80
2 & 3 rows dates are fallen in this month so it should be show in the view and It should exclude 1st row which date has already gone.
Solved! Go to Solution.
Maybe
AND( [Start Date]<=TODAY() ,
[End Date]>=TODAY() )
Sir, the solution given by you is correct and it is filtering the data accordingly! But as you have earlier suggest me for creating the slice and a virtual column to show the sum of Utilization Per Employee. I have added this expression with earlier which was suggested by you to make the slice, Now after adding both the expressions it looks like something:-
AND([ID]=MINROW("RMG","_ROWNUMBER",[Employee Name]=[_THISROW].[Employee Name]), AND([Start Date]<=TODAY(),[End Date]>=TODAY()))
Now if I showing the test pane of this expression it exclude the rows that are fallen in this month.
As well as you have also suggest me to create the virtual column for showing the sum of Utilization Per Employee which is:-
SUM(SELECT(RMG[Utilization Percentage], [Employee Name]=[_THISROW].[Employee Name]))
The Main problem is that I want to create a view that show sum of Utilization of Per employee according to start date and end date column, If End Date is less than Today then it should not add the value of that Row.
Please help to modify these Expressions
This way it's going to take into account the day, so the third row will be excluded on 16-feb-2023
AND(
[Start Date]<=TODAY(),
[End Date]>=TODAY()
)
Now, if you need to include the data the whole month, eventhough it's start and end is at the middle of the month, try:
AND(
EOMONTH([Start Date], -1)<TODAY(),
EOMONTH([End Date], 0)>=TODAY()
)
https://help.appsheet.com/en/articles/2430932-eomonth
https://help.appsheet.com/en/articles/961346-date-and-time-expressions
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |