Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help comparing Datespans

I have a data slicer where I can select a datespan and a table with roughly the following layout:

Start_dateEnd_dateInvoice name
01.05.2021NullRandom Name1
01.03.202004.05.2021Random Name2

I want to have two line diagrams. Both are suppose to have dates as their axis. The first one should show the amount of unfinished invoices and the second one the average age of invoices in the selected datespan.

 

I have tried a couple of times but don't manage to get it working. I'm thankful for any kind of help.