Search Results

Search results 1-4 of 4.

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Data from Spreadsheet -> Widget

    emilabd - - Jedox Web

    Post

    Hey everyone, is there any way to get data for widgets from spreadsheet (or Dynarange). The "data part" of the widget looks like (screenshot): var chart = am4core.createFromConfig({ "data": [{ "name": "The first", "value": 600 }, { "name": "The second", "value": 300 }, { "name": "The third", "value": 200 }, { "name": "The fourth", "value": 180 }, { "name": "The fifth", "value": 50 }, { "name": "The sixth", "value": 20 }, { "name": "The seventh", "value": 10 }],

  • Split year into months.

    emilabd - - Rules

    Post

    Try to split values through "Pattern" in the query. So you do not have to create an attribute for every Dim Time element. ->You can use ([0-9]{4})-([0-9]{2}) regex in order to split monthes from the year. And substitute values in your rule accordingly. Let me know if it helped.

  • You can write some value in a cube with macro and show it in your reports wherever you need. For example, triggering this macro writes the value "1" in coordinatres Dim1 A, Dim2 B, Dim3 C, and you show the value in other reports as Palo.datac(dim1 a, dim2 b, dim3 c).

  • Split year into months.

    emilabd - - Rules

    Post

    Hi. Try use rule templates. -> Activate rule query and select "dimension element like". It should do the trick.