Hi everyone, how is doing?
I have this case with the fx periodToDateCount(), I have some weeks trying to use it in my analysis and I didnt get this one works. I use the fx according to the sintax, I meant my first value is a field, the second one a date like string, the next like " MINUTE" and in the end one construction for my last date. ¿Do have worked very well someone with this function?
Please help me.
@rquintanilla - I would suggest you to go through the below link to understand the exact implementations. You need to ensure that your second argument (evento_fechadeejecucion) is of datetime datatype rather than string in order to get the function working correctly. Also I believe the first argument (accion) is a measure rather than a dimension. Hope this helps!
Thanks u for your answer.
My datasource is in Athena, if I go to Athena I can see the time, but in QS, don’t. If tried to change the format in QS, the field shows it like a date ever. How I can fix this for seeing and working with the times, and another hand, my field “accion” is a dimension, this is right, their values are string.
In the image, Left -Athena Right QuickSight
Hello @rquintanilla - You need to access the Aggregate property of the field or column in the visual and choose Second to display the timestamp portion in detail. Below snapshot shows you the navigation. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
Thanks u so much for your answer and time. This is the solution. A hug for u.
@rquintanilla - Glad to know that it solves your problem. Would request you to mark my relevant post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!