I am trying to calculate an average for 3 variables: cosecha, altura and categoría (which in this example will be product).
I calculated the indicator by which we will do the average which is something like this:
IM 30 - cosecha – categoría = sumIf({saldo_total_capital},{estado_credito} = ‘CASTIGADO’ AND {numero_dias_mora} > 30 )/sumOver(sumIf({valor_desembolso},Altura=0),[Cosecha, {producto} ])
Then I take the average like this:
IM 30 prom - cosecha – categoría = avgOver({IM 30 - cosecha - categoría}, [Altura,{producto}])
Graphically it looks something like this:
Now, I need to plot only this average by Height and Product but removing the variable cosecha damages the graph:
The question here is, is it possible to do what I need, how should I do the calculations to plot the average and get the expected graph?, something like this:
Hello @manromero , welcome to the Quick Sight community!
That error happens because you are missing fields that the visualization relies on. One suggestion I have here is do you need to have every attribute in your calculated fields or can someone them be filters instead?
Thank you very much @duncan !
I don’t understand your question very well but to be clearer, what I need is to get the calculated field IM 30 Average based on Altura, Producto and Cosecha but when plotting, I only need the variables Altura, Producto and the calculated field IM 30 Average excluding Cosecha . I know that when removing the Cosecha field from the visual object the error occurs, but is there any way to solve this?
Hi @manromero, in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - Quick Sight Arena)
