Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Time Series Data Visualization set trend by value manually : UI Builder

Hari1
Mega Sage

Hi,

I am trying to pass the trend by value example: month, date, hour, day manually through client script I see month and day working but i don't see date, hour is working as expected. I see blank screen.

 

Can you please help on how to set date and hour?

 

Below is the script:

var query;
var prd;

if (api.state.trendVal[0] == "today") {
        query = "sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()";
        prd = "day";
    } else if (api.state.trendVal[0] == "yesterday") {
        query = "sys_created_onONYesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()";
        prd = "hour";
    } else if (api.state.trendVal[0] == "last7days") {
        query = "sys_created_onONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()";
        prd = "date";
    } else if (api.state.trendVal[0] == "last30days") {
        query = "sys_created_onONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()";
        prd = "date";
    } else if (api.state.trendVal[0] == "last90days") {
        query = "sys_created_onONLast 90 days@javascript:gs.beginningOfLast90Days()@javascript:gs.endOfLast90Days()";
        prd = "month";
    } else if (api.state.trendVal[0] == "thismonth") {
        query = "sys_created_onONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()";
        prd = "date";
    } else if (api.state.trendVal[0] == "thisyear") {
        query = "sys_created_onONThis year@javascript:gs.beginningOfThisYear()@javascript:gs.endOfThisYear()";
        prd = "month";
    } else if (api.state.trendVal[0] == "lastyear") {
        query = "sys_created_onONLast year@javascript:gs.beginningOfLastYear()@javascript:gs.endOfLastYear()";
        prd = "month";
    } else {
        query = "sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()";
        prd = "hour";
    }

api.setState("trendQueryVal",query);
api.setState("trendPeriod",prd);

 

0 REPLIES 0