jlafee Member


  • We're using the card sort options right now and limiting to 10 rows, but is there a way to disable the A-Z and Z-A sort? Flipping between Ascending and Descending values would do the trick, but right now it's just extra steps to click through alphabetical sorts to get back to Descending.
  • We end up in a similar position at my company, where a story that could be told graphically in 2 or 3 chart cards end up in a single table card for easier export or quick data absorbtion. The secret we use is color series for gain/loss, so there is a real distinction between the ups and downs, and that draws the leadership…
  • @nicolasfeddern, you and I think a lot alike. I have the 400K dataset on the right, and the 2K on the left on a right join. Still having the same issue, but I appreciate the confirmation that I at least have it set up correctly.
  • Yes, @nicolasfeddern, this is all built in Magic. I've done it as a left outer and right outer to see if that helps, both give the same results except for moving the location of the blank columns on the dataset.
  • Thanks, DaniBoy. I've been through that document quite a few times, and so I don't believe there is anything wrong with the way the join is set up. I think there is some just rule, quirk, or missing step in preparing the data that is preventing the final join.
  • Thank you @ckatzman for this solution. Just ran across this scenario for the first time today trying to sort a stacked bar and this was a life saver.
  • Still testing to see if it works, it seems to be just one of many issues I have in this card. Once I can test that it fixed it's part, I'll come back and update.
  • I found a solution that may help. We had our volumes in 2 columns (it can be done with one as well), but it looks for the Fiscal Year (our LEFT statement) and assigns it the correct summed volume, and performs the calculation for var% with those statements. It works, and I can split it up as needed as well as include it in…
  • We have a similar issue in creating a year over year variance percentage that can be summarized. Various customers, and again, massive shifts in scale, but it seems a top level summary percentage would be easier to get to than it is. I'll keep an eye on this thread and see if either of us find a solution.