- Newest
- Most votes
- Most comments
Hi, thanks for your question. Could you give an example of the decimal field value ? Comparison filters are supported for decimal fields but according to the post, it doesn't support for negative and commas.
Hello,
QuickSight supports comparison filter on fields with decimal data as well as with negative values. The only requirement is that data cannot contain comma.
To illustrate this example, I have created the following dataset:
Then I created an analysis with a comparison filter on column values (decimal) with condition Greater than. By filtering data that is greater than -30.20, it's able to filter out the record -200.10 which is out of filter value.
With regards to the following statement from the documentation, a documentation update request has been created internally to get it updated.
Comparison values must be positive integers and can't contain commas.
Relevant content
- asked a year ago
- asked 2 years ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated a year ago
Hi! The values I'm bringing in are dollar amounts. No commas are included in the values, but some of the values pulled are negative. Not sure if those negatives ultimately contribute to the issue if the values being displayed are those being summed. I'm organizing the sum of $ for each unique entity. I'd like to filter the results to display sum of those entities whose spend is above a $50k threshold.