Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm try to load inline table with KPI name and KPI formula ,
after that i config on table the KPI as dimension and the KPI formula as measure but always i got error message.
KPI:
LOAD * INLINE [kpi, kpi_formula
Count, SUM(count)
%Success, SUM({<group_value='GOOD'>}count)/SUM(count)
];
Where am I wrong?
I also tried to insert the formula into a variable without success.
I guess there is something wrong with my syntax
my syntax for measure is something like that , but it still not work- {"=$(=$(=kpi_formula))"}
Thanks
Hi @amiroh81 ,
The correct syntax is: SUM( {< group_value = {'GOOD'} >} count ) / SUM(count)
Best Regards
Thanks
your right but this is not the problem ,
the problem is when i define on the measure the column kpi_formula.
even when i change the formula to your syntax its didn't work
Best Regards
How are you using kpi_formula field in your chart object?
Hi
i tried multiple options:
1. {"=$(=$(=kpi_formula))"}
2.=kpi_formula
3.i also tries with variable ='$(vKpi_formula)'
i think its a syntax issue but I'm not sure what and where ?
Thanks
let's try with the below expression:
if( kpi = '%Success', $(=only( {< kpi = {'%Success'} >} kpi_formula)),
if( kpi = 'Count', $(=only( {< kpi = {'Count'} >} kpi_formula))
))
Its work...
But what can i do if i have long list of KPI's ?
I am looking for an elegant solution for all my metrics
Besides, it does provide a solution to the question but not good enough for what I'm looking for 🤗
thanks for the idea and for your time