Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to display Working days in a filter pane.
For example, in April we have 22 working days so it should show 1 to 22 in Filter pane.
Is there any way to achieve.
I tried using Networkdays but it's giving me Count of working days not list one.
Regards,
Sumit
I am not sure what you mean. If you want to filter something, you will need to have a field in your data set that will be filtered. So for each date in your data, you need to do something that converts the date "4/1" into 1, and "4/5" into 3. Then that is the field you would use in the Filter. If you simply create something on the fly that shows 1-22, that is called a Data Island and it wouldn't reduce your data in any way. Meaning if you clicked 3, it would have no idea that you want to limit the data to 4/5/2021.
Thanks for your reply.
I'm attaching an image, I've a DATE field and I want to create working day field which you can see on right side of attachment.
Can anyone help on this request?