Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I made a line chart, which shows two graphs, with the x-axis being date, and y-axis a price.
Now i want to mark 9 specific points on one of the graphs, with specific dates and the same price. Optimally the markings would also show up in the legend.
Basically, it should look similar to the following picture:
The points i want to mark now are the "Tranchenkäufe", marked with a red dot on the blue line.
I also have the Extension "dygraphs" installed, if this could help.
Thank you,
Paul
Maybe you should use a combined chart instead of a line chart.
put your current expression as a line:
and your new expression (where you focus on ur 9 dates) as points.
let's say in my example I want to focus on the LAST 15 DAYS:
I have to do as follow (with the if)
if(sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)])=0,
null(),
sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)]))
so, you have to do as me:
if(YourNewMeasure=0, null(),YourNewMeasure)
Result:
Maybe you should use a combined chart instead of a line chart.
put your current expression as a line:
and your new expression (where you focus on ur 9 dates) as points.
let's say in my example I want to focus on the LAST 15 DAYS:
I have to do as follow (with the if)
if(sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)])=0,
null(),
sum({<AsOf_Date={">$(=max(AsOf_Date)-15)"}>}[Net (Euro)]))
so, you have to do as me:
if(YourNewMeasure=0, null(),YourNewMeasure)
Result:
If you want to draw users attention to specific insights on a chart have you considered taking a snapshot and creating a data story?
Hello,
thanks for your response, i got it to work.
Only problem left now is, that the marked points are way to small and barely recognizable, because the x-axis has a lot of dates, and i couldnt find an option to increase the size. any suggestions?