Hi,
I have 2 tables.
Table named “RollingCalendar” : shows all dates since January 2020, column name is “fecha”.
Table named “Renta Variable”: Shows the value of the stock per day in column named “Valor Liquidativo”
I would like to create a line graph that shows the value of the stock per day.
When I go to the report section, I select graph line and drag “fecha” from rolling calendar table into Axis And “Valor Liquidativo” from Renta Variable table into values.
This is what I get:
2 issues :
1) How can I get in X axis de full date ( e.g 17.01.2020, 18.02.2020....)? I clicked in the double down arrows but I dont get to the unique date, the more detailed I get is the below which does not help.
2) The values I got is the SUM of the "Valor Liquidative".. e.g: If I look to the value for day 30 I got the SUM of all values of day30 which 30 January+30 February +30 March... whcih is not what I need.
Could you please help?
Thanks
I have 2 tables.
Table named “RollingCalendar” : shows all dates since January 2020, column name is “fecha”.
Table named “Renta Variable”: Shows the value of the stock per day in column named “Valor Liquidativo”
I would like to create a line graph that shows the value of the stock per day.
When I go to the report section, I select graph line and drag “fecha” from rolling calendar table into Axis And “Valor Liquidativo” from Renta Variable table into values.
This is what I get:
2 issues :
1) How can I get in X axis de full date ( e.g 17.01.2020, 18.02.2020....)? I clicked in the double down arrows but I dont get to the unique date, the more detailed I get is the below which does not help.
2) The values I got is the SUM of the "Valor Liquidative".. e.g: If I look to the value for day 30 I got the SUM of all values of day30 which 30 January+30 February +30 March... whcih is not what I need.
Could you please help?
Thanks
