Skip to Content

How to Build WEBI Report Line Chart using deminension(Tablename and (Datetime)

Oct 24, 2016 at 08:47 PM


avatar image
Former Member

capture.pngHello Everyone,

am wondering how to create Line chart using 2 dimensions in WEBI REPORT thr BI Launchpad. I need to build similar report as capture.png in the below screenshot. But I am unable to achieve using WEBI report since both objects are dimensions. Is there any workaround to build Line chart a x-axis is table names and y-axis date withstamp values. Anyy advice/suggestion higly appreciable.

capture.png (97.8 kB)
webireport.png (43.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Oct 26, 2016 at 09:41 AM

Try creating another variable as

= todate([Refresh date];"dd/MM/yyyy hh:mm:ss")

This will create the necessary measure you can plot in the chart.

One more suggestion would be to use =timedim([Refresh Date]), this would add the missing dates in the report.

10 |10000 characters needed characters left characters exceeded