EaziBI Case sensitive searches

[Seema Sharma]

Hello, In Jira, I have users that input a label into a custom field using upper case and lower case, and add dashes etc. I want to be able to consolidate these into one column in a table report on EaziBI, but I'm quite new to this and not sure of the best way to go about it. Can anyone help please?

To give an example, these are the types of input users provide: Test-1, test1, test-1. And I want to aggregate them all into "Test-1" in my report.

Any ideas please?

[Martins Vanags_eazyBI · Accepted solution]

Hey @Seema Sharma ,

It sounds like you could explore account-specific calcualted fields where you can use Javascript to merge similar labels all into one value before importing it into a new dimension/property.

I know for sure you can turn Test-1, TEST-1, and TesT-1 into the same value (test-1) and analyze it as one, but the challenge is to teach that test1 belongs to the same group as it is a shorter string. Anyway, try calculated fields in eazyBI.

eazyBI has had an AI assistant on the Cloud since Aug 2024 (and on Data Center since eazyBI 8.0 version) to help you with the Javascript code definition.

If you have problems with the steps, feel free to reach out to support@eazybi.com

Martins / eayzBI team

[Seema Sharma]

Thanks for your help @Martins Vanags_eazyBI