RevealBi / Reveal.Sdk

Issue tracker - Reveal SDK https://www.revealbi.io/
https://www.revealbi.io/
3 stars 0 forks source link

[BUG]: AVG function only returns integers #213

Closed isabellacarroll closed 1 day ago

isabellacarroll commented 1 month ago

SDK Version

1.6.4

Client Framework

React

Server Platform

Java

Operating System

Mac

Description

When two or more values are averaged, reveal only returns integers. For instance, an average of 1 and 2 would yield 1 , even though the actual average is 1.5.

TorreyBetts commented 1 month ago

Description

When two or more values are averaged, reveal only returns integers. For instance, an average of 1 and 2 would yield 1 , even though the actual average is 1.5.

Do you by chance have the "Fraction Digits" in the field editor set to 0? In case you're not aware of where I'm speaking, when you edit a visualization, you can click on a field that was dragged to say "VALUES" and it'll bring up a field settings dialog that looks like the image below.

image
isabellacarroll commented 1 month ago

We currently have that setting set to 1.

On Mon, Jun 3, 2024 at 2:44 PM Torrey Betts @.***> wrote:

Description

When two or more values are averaged, reveal only returns integers. For instance, an average of 1 and 2 would yield 1 , even though the actual average is 1.5.

Do you by chance have the "Fraction Digits" in the field editor set to 0? In case you're not aware of where I'm speaking, when you edit a visualization, you can click on a field that was dragged to say "VALUES" and it'll bring up a field settings dialog that looks like the image below. image.png (view on web) https://github.com/RevealBi/Reveal.Sdk/assets/5093679/7950f074-be8a-4a0f-820d-5003f6aaf2a5

— Reply to this email directly, view it on GitHub https://github.com/RevealBi/Reveal.Sdk/issues/213#issuecomment-2145985067, or unsubscribe https://github.com/notifications/unsubscribe-auth/AYLNVGDCT5KYCRN4ASGMPUDZFTBTFAVCNFSM6AAAAABIXDFPHOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBVHE4DKMBWG4 . You are receiving this because you authored the thread.Message ID: @.***>

-- NOTICE:  This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. 

Casebook PBChttps://www.casebook.net https://www.casebook.net

PVillarmarzo commented 4 weeks ago

Hi, I tried to reproduce this bug without success. Are you certain you are using version 1.6.4 on both the client and server?

PVillarmarzo commented 4 weeks ago

By the way, there are already versions higher than the one you are using, It's important to keep your software updated, as newer versions come with the latest fixes and new features.

brianlagunas commented 1 day ago

Closing as there has been no response.