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
As strings can’t be imported as measures I mapped them as an property to a dimension. The mapping configuration looks like this
Unfortunately my report does not only show the relevant chipset data for the KPI value but all chipset values.
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