How to know the way DOMO beast mode 'calculated field' is calculating?

Lu_zhang
Lu_zhang Member
in Cards, Dashboards, Stories

In order to solve the problem at Summary Number, I simplify the data.

below is the description of the problem：

https://community-forums.domo.com/main/discussion/66901/what-is-the-problem-with-my-summary-number-need-help

below is the simplified data:

Mockup20240516.xlsx

2024-4-1, data is 1.32, which is what I want to show.

2024-4-2, data is 2.32, which is what i want to show.

In Summary Number area, I want the average, that is (1.32+2.32)/2=1.82

but the Summary Number is 1.888

the calculated field for summary number is (sum (DISTINCT托盘库位数折算) fixed( byStorage Location Name,Storage Date)) * (COUNT(DISTINCT Storage Location Name) fixed (by Storage Date))

Why the average data is not what I want? what is the problem with my design?

Looking for help!

thanks

image.png

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    edited May 17 Answer ✓

    Try just sum, not sum(DISTINCT), if you have 2+ rows with the same value sum(DISTINCT) would only use one of them in the calc.

Answers

  • Sean_Tully
    Sean_Tully Contributor
    edited May 17 Answer ✓

    Try just sum, not sum(DISTINCT), if you have 2+ rows with the same value sum(DISTINCT) would only use one of them in the calc.

  • luyennguyen
    luyennguyen Member
    SQL in DOMO.png

    This case my suggestion we can process using SQL in DOMO

Categories