nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Computed column as series label

amit.hasabnis

Hi, I have a chart with forecast and actual values (captured in the attached screen shot).Along with the graph, I want to show computed column values on the chart (actual-fcst)/actual as % error and not just the actual values from the data set.Any idea how can I show computed column values on the chart? Regrads,Amit

Find more posts tagged with

Comments

SyN

Hey, instead of just displaying your data values, you can build formulas for your y-axis values using the "fx" button in the "Edit Chart" dialogue, second tab. There you can calculate your percentage manually ( like: row[actual-fcst]*100/row[actual] ).

amit.hasabnis

Hi, but wont that change my data series itself. I want to retain the data series as is for Forecast and Actuals. And then just want to show how forecast did compared to actuals.

kclark

If you want to show forecast values vs actuals then create a second series in your chart. Have the first series pull the values from your data set. Then you can apply your formula to the second series in the expression editor like SyN pointed out.