Forum Discussion

Helper I

6 years ago

Solved

Calculate totals per date

Hello, I have 2 tables (see example) First table contains tickets and a creation date. Second table contains tickets and closed date. I want to calculate the total created tickets minus the to...

Need Help

sturlaws
6 years ago
Hi, Foolke

take a look at this sample report I created based on your sample data, is it something like this you are after?

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Foolke

Helper I

6 years ago

amitchandak Thx for the reply. Unfortunately, the solution doesn't work. What am I doing wrong?

I created a date table, made relations. But when adding the visual it doesn't show the months on the X axis. (see scr1).

v-diye-msft : goal uis to make the visual as in screenshot, but with the monyths displayed. The line in this 'line clusterd column graph" should give the difference between created and closed tickets.

Link to sample pbx

Scr1