I have dataset with timestamp (YYYY-MM-DD HH:MM:SS) and created a line plot as shown below. In the controls sections it can be seen that I am using last12 weeks, but the graph is shown with day by day values instead of week by week data. How can I update the graph between day, week, month, year based on the selection from controls section selection.
Hi,
You need to create a field after converting timestamp to integer and use it for the sorting.
This will work for your.
regards,
Naveed Ali
What you see on your x-axis is determined by the date aggregation in your visual. In the example below, the control shows years but the data is aggregated at the month level. The periods that you use for aggregating and for filtering are independent.
If you want to allow users to select the period to use for aggregation from a control, you can take a look at this demo:
https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Switch-Date-Aggregation
Hi @Manoj_Virigineni,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or did the responses provided above help you with a solution?
If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.
Thank you!
Hello @David_Wong ,
The demo you shared is exactly what I was looking for. It’s been a while since you posted this solution, and I haven’t had the chance to test it out until now. Thank you so much for providing this demo; it’s incredibly helpful.
1 Like
Hello @Brett,
Thank you so much for reminding about this and I have tested the solution provided by @David_Wong and it’s working exactly as what I was expecting. I have marked the solution.
Best,
Manoj
1 Like