Ranjita Posted January 27 Posted January 27 Requirement is to create dashboard, where we need to merge two tables in order to show data in the dashboard. However I couldn't find any additional table to add in the measure. But in hornbill wiki, its mentioned that we can add additional table as shared in the screenshots. I am missing something or do I need any additional role to get that.
Steve Giller Posted January 28 Posted January 28 I'm not sure whether the highlighted line should appear - to the best of my knowledge Measures have always been a single-table query.
NeilWJ Posted January 29 Posted January 29 Hi @Ranjita, The feature was never implemented, nor will it be, for performance reasons. Measures only collect data from a single source. The documentation has been updated. What is the exact requirement, what data from both tables do you need to capture measured data for and what are you trying to display in the dashboard? There maybe an different way to achieve what you need. Cheers
Ranjita Posted January 29 Author Posted January 29 I need asset details from asset table and all the columns from request table as well.
NeilWJ Posted January 29 Posted January 29 That's impossible and not what measures are designed for. Can you tell us what the actual business/reporting requirement is i.e. what data will you show on dashboard and why would you need to show all asset columns and all request columns in a dashboard (you are talking about 100+ columns) Cheers
Ranjita Posted February 3 Author Posted February 3 In our organization whenever there is any issue reported against any asset those assets will be linked to that incidents and later we are capturing those things in the report. So that it will give us an idea as how many incidents have been logged for a specific week or a month for any particular asset. This is basically to find trend analysis report. Do let me know if this is possible through hornbill measures or widget. If the above functionality is not possible at the moment can we have an option to create dashboard for the hornbill reports where it will allow us to use multiple tables but at the moment we cant add reports into dashboards.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now