"Preview could not be loaded" explanation

Hello,

 

I'm having trouble getting one of my beast mode calculations to work, but domo provides no explanation as to why its not working.  Currently i've generated a simple table card about direct mail advertising, and on the table i have simple metrics such as title, costs, quantity, etc. 

When i try to generate a "Response Percent" (Total Responses/Total Sent), and its a simple query that was validated in Beat Mode, but when i try to include the column on my card, it reads "Preview could not be loaded, please try again"

Can anyone tell me why?

I've attached images of my Query, and my table before and after i added the column.

Thanks in advance for all your help!

Comments

  • Godzilla
    Godzilla Contributor

    if your total quantities field has 0's then it will error.  

    You may have to Sum the denominator as well. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • @aburrow, did the above reply help you out?