I have a column widget, with a list of 30 offices, and for each one I'm currently displaying 6 values (those are fields with the total income per office, then the income with some expenses, and the last the income with all the expenses per each office)
Is it possible to filter the columns visibility, so that I can "tell the story" with the filters?
I mean, starting showing the total income, then showing the second step with income-expenses A, b and c, and then showing the effective income - expenses a,b,c, d, etc.
All those values are precalculated.
(I tried also creating the columns with a sum of the single values, and then using the filters on the dashboard to remove all the different expenses bigger than 0, to get this visualization, but if I add all the fields in a single value, the filter doesn't seem to work, if I add the single fields as different elements, and I put them in pile, we don't get a difference, but we have just the negative elements adding up in the sub 0 part of the dashboard, while I'd like to see the heights of the different columns moving up or down each time I add or remove something)
Thanks a lot
Please sign in to leave a comment.