The CreatorCon Call for Content is officially open! Get started here.

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