Hi guys,
I have several state indicators.
Now I want to display a “cumulate state” which should show a state in dependence of the state the other state indicators have.
So I need to know the current state for each of the state indicators and then show this value in a separate state indicator.
Any idea? 
The cumulate state. Should be green if for example more then 80% of the other state indicators are “green”. Otherwise the state changes to “red”.
The other state indicators.
I had something pretty much like that.
I have 8 states and an over all state where the over all state takes on the lowest value of the 8 that make it up.
One of the thing I did was want to know how red a red state was. just saying it was red did not tell me how many of the 8 sub states where red, just that at least one of them was red. Yes it was in the data as a string “red”. I had to assign numbers to each state and total them up. I did this in the Data Cube with calculated elements.
If I had your data and wanted an over all state, I would have a calculated element for each sub metric to determine the state (green yellow red … ) either assign it a numeric value or string (if string just count how many are green find the percentage you have green to see if you want the overall to show green.
With doing this in the cube you can change the logic in the sub state indicators (if you want) to read the new calculated column.
Let me know if this helped.
Hi Helge,
There is a way in which you can create a state, denoting the cumulative state or the overall state of your visualized data. For this you can make use of “Formula visualization”:
The formulas can’t directly refer to the states, so a formula visualization can be created to include all the measures that are used for calculating the states and then be used to find the cumulative state.
For example, if the total number of values are known and if you want to find out average then you may simply create a formula visualization with a formula something like:
SUM($StateMeasure$)/count else if the count is a dynamic number then in this case, you can create another formula measure with a constant 1 and thus the sum of this measure will give you the total count. In this case your formula visualization will be something like this: SUM($StateMeasure$) / SUM($Constant (1)$)
Once you have the formula visualization ready you can then apply states to this formula visualization to compare values and assign states accordingly. Once done you can then re-visualize the formula visualization as a data label and just show the necessary information. You can refer to the below mentioned support article for more details on data labels:
https://www.dundas.com/Support/learning/documentation/data-visualizations/adding-a-data-label
I hope this answers your question. Let me know in case you have any queries in this.
Thank’s for your answers!
I think both of theese two answers provides a way to solve my problem.
But anyway I need some time to think about it.
I have many metric sets and states (>40), so I’m still thinking about a way to solve this problem in a more simple way for me.
If I find a very cool solution, I will post it her 
