I have a table with two date fields. Those date fields can contain different dates...
and I need to analyze in the same chart like this:
Does anyone have a suggestion?
Solved! Go to Solution.
Transform the data to a table with only one date field.
Production_Date as Date,
'Production' as Type
Order_Date as Date,
'Order' as Type
Then use Type and Date as dimensions.
Gysbert Wassenaar is the simpler, another way is
1) creating an data island with a "Date" field.
2) using this field as dimension into your graph
3) Adjust your expressions to 'link' to that new field
one solution might be also:
//creation of sample data
LOAD RecNo() as %key,
Ceil(Rand()*10) as Cta_number,
Date(Ceil(Rand()*DayNumberOfYear(Today())+YearStart(Today()))) as Production_Date,
Date(Ceil(Rand()*DayNumberOfYear(Today())+YearStart(Today()))) as Order_Date,
Round(Rand()*1000,0.01) as Value
CrossTable (DateType, Date)
Day(Date) as Day,
WeekDay(Date) as WeekDay,
Week(Date) as Week,
WeekName(Date) as WeekName,
Month(Date) as Month,
MonthName(Date) as MonthName,
Ceil(Month(Date)/3) as Quarter,
QuarterName(Date) as QuarterName,
Year(Date) as Year,
WeekYear(Date) as WeekYear;
LOAD Date(MinDate+IterNo()-1) as Date
LOAD RangeMin(Min(Production_Date),Min(Order_Date)) as MinDate
hope this helps