asked on March 16, 2022
I have all the days of the month and I have if the day is a weekday or weekend.
With that, i need to calculate the number of week days in the month and then the number of days that have itens.
Exemple: https://jsfiddle.net/dsy4o2kz/27/
⋅ March 18, 2022
Hello, Mario,
Thank you for writing us and making the jsfiddle example.
If we understand the issue correctly, we want to suggest the following way to solve it.
Firstly, create a report filter for weekDays to see only workdays (or weekends) on the pivot table.
Then, simply use a distinct count of days.Day to calculate workdays.
Here's an example to illustrate our idea: https://jsfiddle.net/flexmonster/br0p83L9/
Hope it helps.
Regards,
Solomiia
⋅ March 18, 2022
I've tried that way but the problem happen's when I expand the hierarchy. I suppose that i will have to create dummy data with zeros for the count work.
Thanks for the asnwer.
⋅ March 23, 2022
Hello, Mario!
Thanks for the feedback. We are glad that our answer allowed you to move on with your research.
Regards,
Solomiia
