@Massi thanks for sharing the details, since you want to calculate the revenue by segment, you need to include the Period as part of the formula.
For instance * ifelse(sumOver(Revenue, [User,Period], PRE_AGG) >= 1000, ‘03. €1,000+’,
sumOver(Revenue, [User,Period], PRE_AGG) > 500, ‘02. €500 - €1,000’, ‘01. €0 - €500’)*
In the above example, I has added a column “Period” in my data source.
Can I understand more on your use case, do you want to have a Date Range selection filter(e.g. 30days) in the dashboard. And users can also select number of days for the period(e.g. 3days in your example)?
According to the number of days and date range selected, the table can break into multiple periods dynamically? In the example, the first 3days(Jan1-3) will be period 1, Jan4-6 will be period 2… etc.
Or the period will be a fixed one?