Help with table (I wanna represent some values as small diagrams)
hello everyone,
i have this table, where i have this formula as one of my columsn. In representation i selected text, so i see them as the raw number
Sum(If(Measure = 'Revenue', Year))
and i wanna show the numbers as small horizontal bar diagrams, so in representation i select mini chart, and as type "bars", then i have to select a dimension... what should i pick there?
i dont understand...
the first column is "City", so for each city, i wanna have a small bar chart that shows the yearly revenue..
The expression is not correct for what you want to do. It looks at a field in the data model named Measure, and if the value of that field is the text 'Revenue' on the current row, you will sum Year. That means, if Year is 2025 and you have two occurrences, the result of the expression sum(Year) is 4050. That is probably not what you want.
What is the name of the field that actually has the value you need to sum? You should enter sum(thevaluefieldname) and as dimension for the mini chart you should select the dimension that you want the diagram to show, for example year or month or some other time dimension.
