jlafee Member

Comments

  • 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.
    in Filter by both the top 10 and bottom 10 Comment by jlafee November 2017
  • 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…
    in Table cards are ugly Comment by jlafee March 2017
  • @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.
    in Using Data Joins - Limits to Join Data? Comment by jlafee December 2016
  • 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.
    in Using Data Joins - Limits to Join Data? Comment by jlafee December 2016
  • 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.
    in Using Data Joins - Limits to Join Data? Comment by jlafee December 2016
  • 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.
    in Stacked Bar Chart Sorting Incorrectly Comment by jlafee August 2016
  • 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.
    in Is there a way to convert a numerical string to a number value in Beast Mode? Comment by jlafee July 2016
  • 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…
    in How can I calculate a percent of total in a Beast Mode? Comment by jlafee February 2016
  • 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.
    in How can I calculate a percent of total in a Beast Mode? Comment by jlafee February 2016
Default Avatar