@kanupindi in some cases those checkbox or virtual fields are not actually work on Dashboard. You need to check the Trace on Dashboard to find out the query for that specific widget.

Hi @hkabiri , thank you for the feedback. I know the trace works on a page level. Could you please advise how can I check the trace for a widget/ see the query being used?

@kanupindi  in 2023R2 version you can open Dashboards (ScreenId=SM208600) and select which Widget to be active and this way you can keep the one you want to track and deactivate others.

Once you load the Dashboard now you can see the Query for that widget under Trace > Request -->SQL

Here is an example from my local instance:

hi @hkabiri, we are currently using 2022 R2, is there a different way to troubleshoot this dashboard tile issue? thank you. 

 @kanupindi It could be that the parameters aren’t getting passed correctly. When you drill into the widget can you check the filter to see if the names of the filter lines match exactly as they are seen in the widget?

I recently came across an issue which looks very similar to what you’re reporting and it had to do with the filter using @me variable. Inside PXView.prepareFilters(), it was converted into "admin".
Then, in GI, it is processed once again, and here the filter is voided because data types does not match (String).

But this could be seen in the filter on the dashboard showing a different name for the same filter condition that the GI shows.