I have an issue with a calculation with a specific visualization...
I have a quarter field, that is in the following format - 2018Q1, ..., 2018Q4, 2019Q1, etc. It is not possible to have a calendar in the script, as I do not have a date field in my data, so I use directly the quarter field.
Basically, I have created a bar chart and I have used the below calculation in order for each bar to be showing a specific Quarter and to show the data that I need:
This is resulting in the bar chart to be stacked up to а percentage and it is working the way I want it to work.
Now, I want to create a similar logic for a visual, but I want it to be a line chart, and the y axis should be displaying the actual value (not in percentage) of the Data field that I have and the x axis should be distributed to the different quarters that we have so I tried something like:
But they don't work... Any ideas on how to edit the calculation so that it can show the actual values on the y axis, the quarters on the x axis and the line to be representing the data for the dimension distributed to the quarters?