Hello,
I am struggling to find how to correctly format QUARTER in a KPI Visual.
I have an existing visual that does the correct aggregation (QUARTER) but shows the month (Apr 2024) instead of the quarter (Q1’ 2024)
I created the same visual (KPI) in a new Analysis and I can see the QUARTER properly formatted, so it’s possible, but I can’t get how to fix it.
Any clue?
Hello @awsgv , welcome to the QuickSight community!
My first thought here is that there is something about the data between your two visuals/analyses. Are they running on the same dataset or similar fields?
Also, could you share an anonymized view of the KPI and how it was set up?
1 Like
Hi @awsgv. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question. In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena).
Hi There,
I found that in order to properly show Quarter, the format of the Date element in the Trend Group needs to be ‘09-20-24 5:30 pm’ (as an example)
1 Like