Custom interactive filter

[_Gaurav]

Hello Experts!
I had a requirement to create a date range interactive filter. I took the reference from one of the posts that exist here in the community and also worked for me. 
Referenced post 
However, in the same filter, I need to show some selected fields i.e. Opened, Closed, and Created.
I tried making some changes in the widget script section but did not work for me.
1.
'HR cases': {
'table': 'sn_hr_core_case',
'field': 'opened_at,closed_at,created_at,'
},

Appreciate your guidance on this.
Thanks in advance

[AnveshKumar M]

Hi @_Gaurav 

You need to pass only one field for set, you can try like the one shown below.

'HR cases opened date filter': {
'table': 'sn_hr_core_case',
'field': 'opened_at'
},
'HR cases closed date filter': {
'table': 'sn_hr_core_case',
'field': 'closed_at'
},
'HR cases created date filter': {
'table': 'sn_hr_core_case',
'field': 'created_at'
}

Please mark my answer helpful and accept as solution if it helped you 👍✔️

[_Gaurav]

Hi @AnveshKumar M 
Yes, I tried the same thing, and did work for me, but in my case, I need to add this interactive filter on a single dashboard, however, if I add multiple filters as HR Cases opened, and HR Cases closed on a same dashboard then the reports are showing incorrect counts.
That's the reason I was thinking of passing multiple fields in a single filter. Also when we don't pass any field parameter then it is showing all the date type fields present on the case.

[Simran321]

@_Gaurav - Can you please guide me on how to create custom range interactive filter. The reference you posted is the dead link