Forum Discussion
Filter Visual question
One possible strategy would be to create a calculated column in your Details table that calculates the distinct count per shift and then concatenates that with the shift type. Then you would use your calculated column as the slicer.
A basic example would look like...Hope this gets you going in the right direction.
One possible strategy would be to create a calculated column in your Details table that calculates the distinct count per shift and then concatenates that with the shift type. Then you would use your calculated column as the slicer.
A basic example would look like...
Hope this gets you going in the right direction.
works amazing, thank you so much
hello again and sorry for the bother,,, do you know if i can adjust the calculated column script so that when i use another filter, that it woudl update the counts?
example my top filter is from a field called user, if i select a specific user from the same details datasource, the counts to not update specific to that user..
is there a way to add that logic to the script?
I am not sure that this would be possible as a calculated column works within the context of the table that it is created in. It would not 'know' that a slicer has been applied.
