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:
and the data in QS comes to me rounded to 2:05
It is not a calculated field, it is originally like this
any solution?
Hi @agustinmoncada94,
You could try changing the granularity level of your field down to second:
Let me know if that helps out or if you have any additional questions!
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.
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
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.
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!
Good morning, I have a question for you, how would this field be calculated? I can’t figure it
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])
Hi @agustinmoncada94,
It’s been awhile since we last heard from you. Were you able to find a work around for your case or do you have any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @agustinmoncada94,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.
Thank you!