Having a bar chart showing the Access time in the Y axis and the Quartiles in the X axis. When click on, e.g, quartile 1, it will respond to selection and group the customers that belong to this quartile. and so forth...
Having a bar chart showing the Quantity of customers in the Y axis and the Quartiles in the X axis. When click on, e.g, quartile 1, it will respond to selection and group the customers that belong to this quartile. and so forth...
For example: Below I have the boxplot with my data:
The dots represent the Access Time;
I want a responsive bar chart that represents the above boxplot. For example:
The first quartile has the number 48. It means customers who take until 48 days to receive the Product. I expect the following in the bar chart: When I Click on Quartile 1, the selection will give me only the customers that belong to this quartile... and so forth with the other quartiles.
My problem is I don't know if it's possible to have a calculated dimension that can represents the quartiles.
Your code really worked. I Only changed the Expression field. In instead of using Customer_Code, I'm using Max(Access_Time), and now I can have a boxplot quartile representation as follows:
However, When I click on any of those quartiles, the bar chart will recalculate new quartiles for the resulting set. For instance: If i click on quartile 1, the barchart will recalculate the result set and mount the 4 quartiles for it:
My question is:
Is that possible to keep it static? I mean if I select quartile 1, it only show the quartile 1 bar and not recalculate the result set?