Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have :
I have a field "vehicleStatus" that has values from '0' to '12'.
And I isolated the '0' as a count being "Sold Cars"
I did:
COUNT({<vehicleStatus-={0}>} vehicleStatus)
Now I have 2 variables, that i will use so the user can input a min value and a max value to create a range.
I have variables : "vMinCarsSold" and "vCarsSoldMax".
My question is how do I join them togheter so I have for example this output:
Min input: 10
Max input: 20
output = all values in between 10 and 20.
I have tried some expressions but no luck..
Hi @Nolgath
You can try this:
COUNT({<vehicleStatus={"<=$(vMinCarsSold)>=$(vMinCarsSold)"}>} vehicleStatus)
[],
Pedro
Hi @Nolgath
You can try this:
COUNT({<vehicleStatus={"<=$(vMinCarsSold)>=$(vMinCarsSold)"}>} vehicleStatus)
[],
Pedro
Thank you!