user14029 Member

Comments

  • This will work for what I need. Looks like the answer is that you effectively need to hard-code the averages in to the data set through magic ETL before you apply it to a domo card. Was able to make this work for my data, and was able to set up domo cards that will accurately represent the average Monthly basket size.…
  • Sorry, I'm not sure I understand exactly how two groupings would help me. Would you be able to elaborate?
  • Ha! So I messed up my original numbers, and just so happened to pick numbers that accidentally resulted in the exact same average basket size on both Jan 4 and Jan 20. Whoops! I looked in to instead using the Magic ETL flow and it works perfectly well on the per-day level. The challenge ends up being when you group more…
  • Ha! So I messed up my original numbers, and just so happened to pick numbers that accidentally resulted in the exact same average basket size on both Jan 4 and Jan 20. Whoops! I looked in to instead using the Magic ETL flow and it works perfectly well on the per-day level. The challenge ends up being when you group more…
  • @Sweep_The_Leg wrote:Good morning, I believe you could do a standard bar chart. the Y axis would be your date field, and the X, your Sold Price. Then chage the Claculation to Average. It will probably try to SUM or Count it at first. Is that what you're looking for? Unfortunately this wouldn't show the right numbers in my…