I need to change the x axis based on my parameters. I would require something like the first column having date value but with the x-axis showing individual views.
This view(x-axis) needs to be changed based on the parameter control on the right side(highlighted).
But I require the below.
Where 1, 2, 3, 4 are weekly, monthly, quarterly, yearly.
What I do to get around this problem is turn my dates into strings. If you don't like the default format that STR() returns you can do some customization to get the format you desire.
The solution you've given works good for the axis but I don't get the path.
Are your marks set to line?
Sorry Ivan, I changed the Mark as "path" and it works now.