Create a filter based on a variable Select date field.

[Jonathan Brown]

I create a service catalog request. On the request users can select a date.  In platform analytics I was trying to create a dashboard with a filter based on the selected variable date. Since it is a date field I hoped I could but if I select date date field in the filter I cannot access the variables. And if I select Single Select as the filter type if I can access variables but the date field is not a selectable field. Anyone else run into this? I also seem to not be able to pull a variable date field in any of the filters on platform analytics. The only date field I find are the system ones. 

[kaushal_snow]

Hi @Jonathan Brown ,

Platform Analytics does not support date-based filters on catalog variable fields. Because variables aren't actual table columns. Only system date fields (e.g., sys_created_on, end_date) appear in the filter.

Please follow below links:

https://www.servicenow.com/community/platform-analytics-forum/platform-analytics-date-filter/m-p/313...

https://www.servicenow.com/community/platform-analytics-forum/platform-analytics-date-filter-issue/m...

Try this once and let me know. If you find this helpful, please accept this as a solution and hit the helpful button..

[Ankur Bawiskar]

@Jonathan Brown 

I believe it's not supported in platform analytics.

If my response helped please mark it correct and close the thread so that it benefits future readers.