Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I need your help.
I have two sources of data. Sales and Repairs and each has a distinct date (date sale, date repair).
I need to implement a chart with a MM.YYYY date dimension and a measure with the repair ratio divided by the sales (number repairs per month / number sales per month).
The data source is linked with the material number.
How to manage the dimension date on my KPI ?
Thanks for your suggestions,
Fred
Hi!
1) Create MonthYear field for both tables: Date(date sales,'MM.YYYY') as MY, Date(date repair,'MM.YYYY') as MY
2) Create calendar table.
Calendar:
NoConcatenate Load MY resident TabSales;
Load MY resident TabRepairs;
3) Drop MY fields from TabSales and TabRepairs
4) Create chart with MY dim and expression like: Count(repairs) / Count(sales)
Regards
Hi!
1) Create MonthYear field for both tables: Date(date sales,'MM.YYYY') as MY, Date(date repair,'MM.YYYY') as MY
2) Create calendar table.
Calendar:
NoConcatenate Load MY resident TabSales;
Load MY resident TabRepairs;
3) Drop MY fields from TabSales and TabRepairs
4) Create chart with MY dim and expression like: Count(repairs) / Count(sales)
Regards
Hi Zhandos,
I'ts very good and simple your solution ! Thanks !
Kind regards,
Fred