Hi All,
I need some help on a chart I am working on.
I want to represent a trend of submitted and logged tickets by month. The problem is that in our company we use a non-trivial calendar. So, for now I have 2 tables - one for the Month/week/etc. for each close date and another table for the same fields (month/week/...), but for the Submit date.
If I make a single chart/table with dimension = Close Month and expression count(Request) and another table with dimension=Submit Month and the same expression, everything works just fine. How can I unite both charts/tables in a single one ? I want to have only one dimension Month and both trends, but I lack of ideas how to realize that.
Thanks for the help in advance!
Sergey