We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Dynamic Date Condition (Today / Yesterday / 90 Days+) for Percentage Widget Using PA

Nilam Narote
Tera Expert

Hello All,

We have implemented a percentage-type widget that shows the percentage of satisfied surveys.

  • Table: asmt_metric_result
  • The widget is built using Performance Analytics
  • It calculates the percentage of satisfied survey responses

On our dashboard, we have multiple tabs:

  • Today
  • Yesterday
  • 90 Days+

Now, the requirement is:

 - The same percentage indicator should be displayed on all three tabs.
 - However, the result must dynamically change based on the selected tab (i.e., filter by Created Date such as Today, Yesterday, Last 90 Days).

Currently, the widget does not dynamically adjust based on the tab selection.

 

Any suggestions or implementation guidance would be greatly appreciated.

Thank you in advance!

@all 

0 REPLIES 0