Eduard Lebedyuk · Jul 23, 2019

DeepSeeWeb add markers to line chart

I have this fact table

CheckTimeErrorMarker (1 or 0)
2019-01-01 00:01:0010
2019-01-01 00:02:0051
2019-01-01 00:03:0020


And the cube which is pretty much 1:1.

I have build an MDX:

SELECT NON EMPTY [Measures].[Error] ON 0,NON EMPTY [CheckTime].[H1].[Minute].Members ON 1 FROM [CHECKCUBE]

Which produced this chart in DeepSeeWeb (there's obviously more data, but you get an idea):

However, I want to add a Marker - if it equals 1 then I need some indication on the chart, so the graph should look like this:

Is there a way to do that in DeepSee or DeepSeeWeb?

0 0 2 127
Log in or sign up to continue

Hi Ed!

One of the ways to expand the functionality in DeepSeeWeb is to expand the library of DSW widgets. 

The standard way is to implement the needed functionality in javascript (or take the one which already does what you want from the Internet) and make use of this javascript-widget as a new one with portlets.

Then introduce a new class derived from Portlet class (e.g. SmartMarkersPortlet) into the namespace and make sure that the name of the javascript file is equal to a classname.

Make sure to put the js file into /addons folder of dsw.

Then add the new SmartMarkerPortlet on a dashboard, provide the datasource and work with it as with usual widget.

Check how htmlViewer addon is implemented as an example.

Out of curiosity - if Combochart doesn't work for you? I think it can show the data in different styles for different series on a one widget.