Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a line chart to graph the change of the value of kpi_curr_val.
In my data set, I have multiple values for kpi_name. In my chart I created a calculated dimension to restrict the chart so that it will chart only one kpi value.
Calculated dimension:
=FieldValue(kpi_name,'Advances Outstanding')
I don't know if this is the right approach. In the expression tab, I added =kpi_curr_val as the expression. The objective is to simply chart the change over time for a specific kpi value.
The issue I'm seeing is that the values on my line chart (=kpi_curr_val) do not seem to be related to the dimension (=FieldValue(kpi_name,'Advances Outstanding').
Hopefully this makes sense. I need to ensure that there is a relationship between my calculated dimension and the =kpi_curr_val.
Thanks.
Hi,
I figure out a solution that seems to work.
My expression is
SUM({$<kpi_name={'Advances Outstanding'}>} kpi_curr_val)