Use measures in pages

I have build a report on a dataimport from excel

I build a report where the 4 measures are shown in a graphic (Line)

I would like that the user could select (with dimension in pages) to see only the Android or IOS measures. Is this possible?
I tried a lot, but nothing worked, so I missing something crucial to make it work or it is simply not possible.

Hi @_P3

Thanks for posting your question!
For you to be able to filter the report by Dimensions, you should re-do the data source. The file might look similarly like in the screenshot below (with the additional columns you have in your file). The idea is to list the dimensions you want to filter by - in a separate column.

That would allow you to map the columsn in the following way:

And then use the dimension as a filter

Considering that this may be quite time consuimg to redo the source file, you may conisder uploading two separate reports - one for Android and one for IOS and then add both reports in one dashboard (Create dashboards)

Best wishes,

Elita from support@eazybi.com

1 Like

As I thought, I should denormalize my table on the level of type. I had hopes it could be done, but should have known better :slight_smile: Always denormalize.
Thank you for the effort!

1 Like