I need to create a bar chart showing values in different intervals. I have a lot of data, and my primary dimension is an "ID notice" that has a value of anywhere between 100.000 and 10 mio. Euros. I want to group them so that each bar in my chart will contain all values between e.g. 100.000 - 500.000 euros, 500.000 - 1.000.000 euros etc.
My best bet so far is to make a dual if / nested if calculated dimension, but I have an idea, that there are better options.