How can i plot a data with date range in yellowfin?

Sumit Patel shared this question 44 days ago
Answered

Hi Team,

Hi have a table in a database with date range as follows :

id, data, start date, end date

1,10,'2014-01-05','2014-02-06'

2,23,'2014-03-17','2014-05-16'

3,10,'2014-04-25','2014-06-24'

....

how can i plot a line chart on basis of the above data (Without transformation).

Comments (3)

photo
1

Hi Sumit,


Thank you for your question.


Firstly, could you please send through your /info.jsp page?


I'm not clear on how you aim to display this data with a line chart. Do you have an example of how this might be displayed? Are you aiming to use the Start Date or End Date in the Visualisation? You will not be able to use both Date fields in the Chart. When creating a Chart with Time Series information, typically you would place the Date Field in the horizontal axis and the metric in the vertical axis. On the Chart Builder page you can then turn on Time Series for the horizontal value.


Otherwise, you could create some sort of Calculated Field such as days between with the two Date fields in Yellowfin to get the desired output. If you could be a little clearer on what you want to show that may help provide further guidance.


Kind regards,

Simon

photo
1

Hi Sumit,


I'm just following up on your question. If you could please send through your /info.jsp and let me know the way that you envisage visualising this data, I might be able to provide some guidance.


Otherwise, if I don't hear from you I will go ahead and mark this as closed due to inactivity.


Kind regards,

Simon

photo
1

Hi Sumit,


I'm just messaging to let you know that I am marking this question as answered for the time-being, due to inactivity.


Please feel free to re-open the question by responding here, and I will get back to you shortly.


Kind regards,

Simon