Facts table is different on Indicator source and Breakdown source

Shilpa44
Giga Contributor

Hi,

The facts table is custom table in the Indicator source and the table has a field called Breakdown which is of choice type. It has same values as syslog_transaction table 'Type ' feilds and it was added manually to the Breakdown field in the custom table so sys id's are different .

In the breakdown source , the table is syslog_transaction table. Now, when i run the job i get the data from indicator source but i dont see the scores for each breakdown. Can someone tell me how can we relate Indicator source and breakdown source when the facts table is different.

Thanks,

Shilpa

6 REPLIES 6

Naresh27
Tera Guru

It doesn't matter about facts table b/w indicator and breakdown source.

is you breakdown field is a custom sys_chice field ? Which seems it is. Can you post a scheenshot of your breakdown

Shilpa44
Giga Contributor

Hi Nari,

I was able to resolve the issue. Thanks.

But then, i am getting below error when i open dashbaord.

java.lang.IllegalArgumentException: to must be after from
 
Do you any idea about this?

Hi Shilpa,

Please refer the below links :-

https://community.servicenow.com/community?id=community_question&sys_id=38534325dbd8dbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=51bb4ba1db9cdbc01dcaf3231f96...

Please mark it Correct or Helpful if it works based on impact....!!!!!

Warm Regards,

Priyanka

find_real_file.png

www.dxsherpa.com

Hi Shilpa,

If you found my answer worthy, Please mark it correct or helpful. So other can refer it easily.

Thanks,

Priyanka

find_real_file.png

www.dxsherpa.com