Report containing numeric an string based column values

Questions & Answers
,
1

Hi,

I need to provide a report that contains numeric and string based column values. The configuration is based on eazyBI for Jira Cloud, the data is extracted from an Excel spreadsheet (later we want to use a MS SQL Server).

The spreadsheet looks like this
image

As strings can’t be imported as measures I mapped them as an property to a dimension. The mapping configuration looks like this

image
image2188×486 120 KB

Unfortunately my report does not only show the relevant chipset data for the KPI value but all chipset values.

image
image789×843 127 KB

How can I remove the rows where no “Kpi Value” is defined so that only valid combinations are shown.

Thanks for your help. Kind regards
Matthias

2

Hi @matthias.bauch

Thanks for sharing your use case. It is always beneficial to see the screenshots, to understand the root cause.

Could you please try enabling the “Nonempty” option for Rows and see if the report returns the expected data?

image
image1192×748 59 KB

Best regards,

Elita from support@eazybi.com

3

Hi @Elita.Kalane
thanks a lot for your response. Now it works.

Thank you
Matthias

1 Like