I'm currently struggeling with a visualization and need some help.
As a basis I have three columns from a data table:
-ProductionDate (DD.MM.YYYY DateFormat)
-SalesDate (DD.MM.YYYY DateFormat)
Now I'd like to show a line diagramm with the date in MM.YYYY format on the y-axis and two line graphs, one for the count of products per production month (ProductionDate) and one for the count of products per sales month (SalesDate).
I found the following formula for getting the desired date format:
But I dont know how I can combine both dates from "ProductionDate" and "SalesDate" as a dimension for the diagram.