Marlene Knaup

1. Community
2. Frontend, Designer and Consumer
3. Coloring scatter plot

Hi Yakup, I have one idea for this but there are multiple steps. 1. Create a calculation where you define if the measures are both over 50% (in my example 40%): -->   2. Create two color agents for...

• View comment
• Edited December 01, 2023 14:09
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Show all dimensionvalues on x-axis in bar chart

Unfortunately, I don't think there are any scroll bars in any diagrams.

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Rolling 12 month sum

The formula is sum(0, -11:0, m1) to get the sum of all 12 previous months.

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Crosstable formatting - Text in an open hierarchy?

You can try this...    

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Show all dimensionvalues on x-axis in bar chart

Forcing is not possible, but you could change the labels to vertical:

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Rolling 12 month sum

There is a smart calculation for accumulating. If this is not what you mean, I would need an example in e.g. Excel. BR, Marlene

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Rolling 12 month sum

Hi Janus, If I understand correctly all you need is a dynamic time filter like this: Using the "Editor" is necessary, because the default filters do not cover the whole last year like you need: C...

• View comment
• 0 votes

1. Community
2. User Tips and Tricks
3. Share of sale to each customer?

Hi Michael,  you could try this formula with r(0,1): sum(d-1, 0, m1) / sum(d-1, 0(r(0,1)), m1)

• View comment
• Edited November 07, 2023 14:25
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. How to get a Custom Color Palette to use the same colors when drilling down, like Automatic.

Hi, I think this use case would be a nice feature request. Colors may have a big impact on the analyzability of data.

• View comment
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. User dimension in 'ignore criteria'

I dont think so, but maybe this helps: Ignore criteria on User dimension elements – TARGIT Community 

• View comment
• 0 votes