Rounding of values

Question & Answer
,
1

Hello good day, there is a data where I rounded the values ​​in multiples of 5, for example I have this order (221174) at this time:image

and the data in QS comes to me rounded to 2:05
image

It is not a calculated field, it is originally like this

any solution?

2

Hi @agustinmoncada94,
You could try changing the granularity level of your field down to second:
image

Let me know if that helps out or if you have any additional questions!

1 Like
3

Hello good morning, I already did what you’re telling me before and it still appears as I sent in the photo, it continues to round the values ​​in multiples of 5, I don’t know if I have to make a calculated field.

4

Hi @agustinmoncada94,
Apologies, maybe I misunderstood your original question…so you’re saying that your field is rounding up to every 5 minutes but you would not like it to round at all?

Thank you

5

Hello, exactly, I want it to bring me the raw data as shown in the first image and what QuickSight does is round it up for me.

6

Hi @agustinmoncada94,
That is interesting behavior. Since it’s not a calculated field, what if you tried to do a parsedate calculation. You can setup the desired format that could include seconds, which should stop it from rounding up to the nearest 5.

Let me know if this works for your case!

7

Good morning, I have a question for you, how would this field be calculated? I can’t figure it

8

Hi @agustinmoncada94,
I’m not sure of your field options in your dataset but it may look something like this:

parseDate({YourField} , [MM/dd/yyyy HH:mm:ss])

1 Like