Issue with Current selections box value on selection of dynamic buckets created in chart

[#1]

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.

[Anonymous]

Current Selections shows selections in fields.  In your case, the bucket is not a field, hence it is not really selected.  The Vendors are.

If you create bucket as a field in the script, it will work as you require.

[aveeeeeee7en]

Hi Developer

Try the Attached Qvw.

Instead of using Calculated dimension you can do calculation in the Backend.

Michael is right  as Current Selection Box shows selections done in the fields.

Regards

Aviral Nag

[#4]

Hi Michael / Aviral,

Thank you for your response.

Unfortunately, calculating it at the backend or in the script is not an option since the Chart is intended to be dynamic for any selections made in dashboard. (I might need to create a aggregated table with a lot of dimensions; which will be very complex).

I understand that bucket is not a field and hence will not be readily available in the current selections box. I am looking for some workaround wherein I might get to manipulate on the UI to show the selection of bucket.

Thanks,

SK

[tresesco]

You can show the selection in a text box like in sample attached.

[#6]

Hi tresesco,

Appreciate your response and solution.

But the Users specifically want it in the Current Selections Box itself.

I could format the Text Box to merge or overlay on the Current Selections Box. But then it poses other challenges like unavailability of Clear button, etc.

Rgds,

Shantanu

[#7]

Hi,

Anyone got a chance to look into this?

Regards,

SK

[rustyfishbones]

You could add an action to the Text Object to clear selections.

Not ideal but it would sort the clear selections part

[marcus_sommer]

You could split your task in many textboxes and buttons and control this whole per visibility ... not very elegant and it's a lot to fiddle ...

Another idea is to take a pivot and create from the current selections a dynamic dimension (selected field) and the expression showed the selected values. A single action could be triggered per selection any from those dimension-values (field action) - perhaps you could also create several such dynamic dimensions each for another trigger or combine it with an inputfield within an expression.

It won't be a simple task - good luck.

- Marcus

[marcus_sommer]

It's an interesting thing - I have little tried and the pivot itself isn't very complicated but a trigger on field-actions don't work because it's a dynamic dimension. Perhaps there is a way to switch the sheet per link inside a pivot-expression to trigger any action and return to origin sheet. Otherwise you could put buttons over the pivot.

- Marcus