Scotsman143 Member

Comments

  • @G_Grey Thank you! I got it to work as well, very neat solution. Very weird that they need to share that one row as a control (in your case, the "RumIsTheAnswer"). I'm unsure if I'll stick with this solution because of the need to include the control in the filter. Not ideal for my customers. @Domo please take a look at…
    in Compare two peer groups Comment by Scotsman143 January 2023
  • @G_Grey and @Billobi did you guys end up solving this? I'm running into the exact same issue that you encountered @G_Grey. The only solution I came up with logically is a full outer join of the two datasets rather than an append. You can set the MAX(Money1) for the benchmark and then the AVG(Money2) for the peer group.…
    in Compare two peer groups Comment by Scotsman143 January 2023
Avatar