topic Help on Chart Type or Synthetic Dimension in App Development

Help on Chart Type or Synthetic Dimension

hildaelorm — Mon, 08 Oct 2018 12:17:42 GMT

Hi All,

I want to create a chart like the ones below, what is the best way to achieve it?

Thanks for your help in anticipation.

Re: Help on Chart Type or Synthetic Dimension

felipedl — Mon, 08 Oct 2018 18:03:12 GMT

Can you provide more info on what you want to achieve?

What is the "Sales (exclude)" / "Sales (include)" dimension.

I'm assuming you want to aggregate the multiple bars into one same bar, but only with pictures its a little hard to help.

Re: Help on Chart Type or Synthetic Dimension

hildaelorm — Mon, 08 Oct 2018 19:00:14 GMT

Hi Felip,

The first chart is measures only (I've been able to achieve this with valuelist but only for the 'exclude' part), no dimensions, the exclude is a particular division- FFME which is separated in the second chart. How do create a bar chart with two levels of synthetic dimensions?

The second chart is the same as the top one except it has an additional dimension grouping, i.e. by division.

Thanks for your response.

Re: Help on Chart Type or Synthetic Dimension

dplr-rn — Mon, 08 Oct 2018 19:29:39 GMT

Not sure i understand your logic completely but i think you may need value list (include, exclude0 as one of the dimensions

check below for example

ValueList() – For those tricky situations