I have created a live dashboard that count the rows to show number of tickets with status.
I used the following formula and its working fine (CountRows(Filter('NWC - Support',Status.Value="Pendding"))
But I am not able to set it to count the tickets for Today only, it counts all the tickets regardless in my SP list.
If anyone can help I will be grateful.
Solved! Go to Solution.
CountRows(
Filter(
'NWC - Support', Status.Value ="Pendding" && Text(Created, ShortDate)=Today()
)
)
Hey @whissi ,
if you want the counts of records created today, the logic could be this
CountRows(Filter('Datasource',Created = Today())
Thanks @RussellXDamali , I used that and it show nothing that's why I am asking , maybe I missed something.
CountRows(
Filter(
'NWC - Support', Status.Value ="Pendding" && Text(Created, ShortDate)=Today()
)
)
@Drrickryp I guess both codes are correct but the problem is from my side, Power App is not reading my SP file correctly because my date is (date + Time) so the formula is not getting the TODAY correctly, I might be wrong.
Example how my date look on SP:
That's why I wrapped it in a Text() function with the ShortDate option.
User | Count |
---|---|
257 | |
110 | |
90 | |
51 | |
44 |