Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded