Last 4 digits formula

I am an ESO user and am trying to create a widget that will show only the final 4 digits of an incident number. The beginning of the incident numbers are not always the same but the last 4 are what I need. In excel I use =right(A2,4). I then use this list in excel with an =if formula (=if(c3-c2=1,"","missing") to show me any incident numbers that were not reported. If there is a way to make this part of the widget also, it would make my job that much easier. Thank you.

tcfd135

Posted 11 months ago·Last reply 8 months ago

5 comments

DRay

·8 months ago

Hi tcfd135,

I’m following up to see if the solution I offeredTriAnthony worked for you.

If so, please click the 'Accept as Solution' button on the post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

DRay

·9 months ago

Hi tcfd135,

Just checking in to see if you were able to get this resolved. Do you still need help?

DRay

·10 months ago

Hi tcfd135,

I wanted to check in to see if that documentation was able to help you. Do you still need help with this?

DRay

·10 months ago

Hi tcfd135,

Can you check these documents and let us know if they are able to point you in the right direction?

For Pivots - https://developer.sisense.com/guides/customJs/jsApiRef/widgetClass/pivot2.htmlFor non-Pivots - https://docs.sisense.com/main/SisenseLinux/transforming-query-results-with-python.htm

Thank you.

DRay

·11 months ago

Hello tcfd135,

Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.