Forum Discussion
How to display mutliple value for the same date
Hi, Anonymous
After my research, you can try to achieve an approximate effect by adding a secondary column, the steps are as follows:
- Create an index column and change the index column type to text;1
- Create a new Custom column, use the formula: = "-" & [Index], and then delete the index column;23
- Create a line chart and add the Custom field you just created to Axis, and you will see a hierarchy on the line chart;4
- Select Expand all, the corresponding screen may be what you want, the result is as follows：5
Here is demo , please try it：
Best Regards,
Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi !
Thanks for your reply and the time spent to try something :)
I just tried it and it looks perfect. I will accept your answer as the solution !
Quick questions about your answer:
1 - Why this "= "-" & [Index]" and not only the index ?
2 - How can I remove the display of the index on the "x" axis ?
Thanks
Solution SageHi Anonymous ,
For your question, I hope the following answers can be resolved:
1. This formula: = "-" & [Index]", just to visually distinguish better, you can also use only the index, but it may be visually confusing, you can also customize a formula that you feel better;
2. The chart will aggregate options with the same value, so the value of the x-axis must be unique to achieve the desired result. If the display of the index is removed, the ideal result will not be achieved.
Best Regards,
Joey
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.