Search Results

Search results 1-3 of 3.

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

  • Pareto Chart

    dominik_l - - Jedox Web

    Post

    Should be possible, using different chart types for the series in a chart, given that your source data range already contains both the absolutes (for the columns) and the percentages. If done this on the "Top Ten Analysis" report in the MIS Cockpit Demo. Chart Range there would be C10:E34. Change the chart type of the "kum%" series to line. You can play with the axis formatting and label formatting to get the numbers formatted properly. See attached image.

  • If you enable the "Regular expression" option on AFilter, you can try with an expression like this: ^(?!.*DP.*) That would filter anything where DP occurs. This one should filter out exact matches (i.e. where attribute is exactly DP), though I'm not really a RegEx expert: ^(?!DP$).*$

  • Check For value in Cube

    dominik_l - - Jedox Web

    Post

    You can try with the php function palo_getdata_export() (see the PHP API documentation in Knowledgebase for details). It allows you to set the option "ignore_empty", meaning it would return you a (potentially long...) list of cell coordinates with values which are not empty.