For the twbx attached below I am experienceing 2 issues:
1) Filter actions: I would like to have two filter actions in this dashboard. One action comes from the "branches" sheet, where a user can select the column name of a metric. This selection will change the "bins" sheet to display bins according to the selected metric. The 2nd action comes from the "bins" sheet, where a user can select a specific bar in the bar graph, and the "branches" sheet will then display all branches that belong to the selected bar.
The action used to select column name of metric seems to work fine, but selecting the branches within a bar only works for the first bar, not for the others.
2) There seems to be an issue with the distinct count of branches in the first bin. The first bin is summing up all distinct branches, regardless of what their metric value is. Each bin should only contain the distinct count of branches whose sum of the given metric fall within the bin range. For reference, I built these bins dynamically using this resource: https://www.flerlagetwins.com/2023/06/dynamic-bin-size.html
I have been stuck on solving this for quite some time, any help would be appreciated.
Thanks,
Maclain
@Mac Neal
Hi, in this case you may round the bins calculated field to:
ROUND(INT([Metric Value (copy)]/[Bin Size]) * [Bin Size] - IIF([Metric Value (copy)]<0,[Bin Size],0),6)
When using dimension numbers as filter, the technique is to round the number of decimals. That way, Tableau will be able to filter using the numbers.
For your second issue, I have modified a little bit the calcs, to resemble the histogram using a fixed at the measure name level, and modifying accordingly the calculations.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
