Gretings!
I need to create a comission indicator inside a dashboard. The comission value will be sum of sales * comission index, but this comission rate needs to be defined directly by the user. Ideally, the user will select a value between 0-150 using a slider and that selected value will be multiplied by the sum and showed in a single value chart.
I tried to create a table with numbers from 0-150 and then join with sales table, and then create a measure using this value, but this doesn’t worked. I think that Liquid variables will be the answer, but I don’t know exactly how to implement in this specific case.
Any thoughts?