I need to solve this:
In my model, I have several date fields in a single table called "Fact_Table". The data fields are:
The Data model contains a Master Calendar table linked only by "OrderDate" field, but I want to manage both date fields in the same master calendar, with a generic date field. I do not know how to do...
An example (or idea) in the image below:
I would like it to be available in the dashboard advanced selections like “orders placed in september but payment in october, and visualize KPI's like "orders placed in current month Vs. last month", or "Quantity Invoice payment in current month", among others. (using set analysis and points in time reporting)
I must comment that "Fact_Table" contains several conditional fields and I have used "Apply map" function in this fact table. (see the example.qvw file)
I really appreciate your help, I think it's not difficult but I'm still learning advanced script.