Looking for idea

[nagoor]

Hello Champs, 

Need a help to create a dynamic chart data. I have 3 data table, eg, 1st table contains all the open issues raised 2nd table contains issues raised one that particular day and the 3rd table contain issue closed that particular day(it may be raised a week ago also).  

I want to create a common data field as a date and count of open issues / Created issues  / Closed issues in a single chart. 

Could you please me, i have attached my requirement based on excel chart. 

 

[jthomson]

Seems trivial if you make a date table

[nagoor]

then give a solution please

[jthomson · Accepted solution]

---

wrote:
then give a solution please

---

Make a date table, link your existing tables to it, and then shove the data you want into a bar chart, it is that simple