Calculated Single Value Chart based on User Input

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?

0 0 83
0 REPLIES 0
Top Labels in this Space
Top Solution Authors