Exclude records created on weekends and include the same on monday column Bar report

[Priyansh_98]

Hi Team,

I have requirement in reports where i have to exclude records created on weekends i.e. sat and sundays.

and the count of those records i have to show it in same day column.

Report type : Bar Chart

in this report below are the filter i have applied

now i want to exclude the record created on weekends, for that i am applying below filter

to exclude the records created on weekends. but in that data is not correct.

The AIM is build this report is to check older data in the system created on weekdays but still pending for an action.

any one having any solution for this???

Thanks..!!!

[AndersBGS]

Hi @Priyansh_98 ,

Not sore about your requirement in your problem description, since you state "count of those records i have to show it in same day column" - Which records needs to be present in same day column?

What is not correct according to your statement "to exclude the records created on weekends. but in that data is not correct." - What do you see instead?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Priyansh_98]

Hi @AndersBGS ,

thanks for your response..!!

i want to override these column naming to weekdays,

same days =  mondays(after naming)

2 days = tuesday (after naming) & so on... (excluded column - sat and sundays)

and whatever records are created on sat and sundays, those records count i want to include in monday column.

is it possible to do it??

[AndersBGS]

Hi @Priyansh_98 ,

No, that is not possible, but why not create a trend time series and trend by day? With below filter:

You will be able to trend by day of week:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders