can i use eazybi to display simple report without measures from SQL datasource

[eric anier]

i have a simple table data as shown below and I just want to show it as a report using eazyBI, and i dont have any measures.

just want to display it as a report in dashboard

SQL query result

group user property

Accounting userX Head

HR

IT userI Head

Audit userA

Treasury userT

[Lauma Cīrule · Accepted solution]

Hi!

In eazyBI it is always necessary to import at least one measure which at very simplest could be a count Measure. You could add a column that returns 1 for each line to count how many entries have been imported.

Another option is to add 'Date count measure' if you have a Date in imported data. Please see example created_at date mapping in documentation.

You can contact me directly at support@eazybi.comif you need any additional help with additional data import!

Kind regards,
Lauma

[eric anier]

hi lauma, thank you so much for your assistance..