filtering by custom prompt

Summary

We setup a custom prompt but we need to understand how to link into filters

Content

Hi Ladies & Gentlemen,

we configured a custom prompt based on following SQL code:

 select   CASE

WHEN ("Worker Assignment Details"."Employee Category Code" IN ('VTV_HOUR_DIR','VTV_HOUR_IND','VTV_MANHOUR','VTV_MANSAL')) THEN 'COGS' 

ELSE 'SGA' END 

from "Workforce Management - Worker Assignment Real Time"

and it works properly. We need to understand how to use it as filter in the analysis.

 

Could you help us?

 

Thank you!

Nicola