Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a chart which has a calculated dimension to evaluate buckets in the UI. The dimension expression is -
=if(Aggr(sum(Spend),Vendor)<100, 'Less than 100'),
if(Aggr(sum(Spend),Vendor)<200, '101 to 200'),
'Greater than 200')))
When any bucket is selected by the User, in the current selections box, it displays the Vendors associated with the Buckets (this is correct since our bucket is calculated on the basis on the Vendor amounts).
The expectation is that the Current Selections should show the bucket selected and not the Vendor.
Any ideas to achieve this? Attached is a test app with the expectation.
By using from the current selections as filter to $Field there are also trigger possible.
- Marcus
Hi Marcus,
i created a pretty similar version 😉 Have a look:
Current Selection Alternatives or Current Selection Alternatives (QVW)