And, if you don't have all the DayNumbers even in the master table, you can produce them in the front-end using continuous dimension axis(Axes tab) like attached sample.
A_tres.qvw 147.5 K
What do i do if i want to link it to an integer table?
I can do like this:
RowNo() as ID
RowNo() as Int autogenerate(100);
left join (IntTable)
DayNumber as Int,
But the problem is here, if i use Int as an dimension (i would get 100 values)
Is there any way to make the autogenerate generic so i can use the maxvalue in DayNumber (theni would only autogenerate up to the max value)