How to calculate duration b/w two date fields of two different table and represent them bar chart
Hi All,
I have two table with Create table has contain RiskCreateDate, if any action hs been taken on perticular Risk of product it will be updated in Action table with the like ActionctreationDate, so i need to calculate duration between the Risk creation and Action taken Month on Month for last 12 months duration need to display
I have done like Interval(ActionctreationDate-RiskCreateDate,'hh:mm:ss') //Both the date formats same format.
How to show month on month on bar chart or line chart with dimension as month