Forum Discussion
Plotting 2 dates from same table onto line chart
HI graemejones ,
You not need to modify your database, my suggestion do these operations on data model side.(create a calculated table to expand original date range)
Steps:
1. Use unique fields and two date fields to create a calculate table with expand records.
2. Create relationship between raw table and calculate table based on above unique field.
3. Use new table date field as axis, raw table amount fields as value to create visuals.Regards,
Xiaoxin Sheng
Hi Anonymous
Thank you for your help, I am however having trouble following this through and don't really seem to be getting anywhere.
I have tried to follow the linked example adjusting for the table and column names in my database but I'm having no luck. Is there any chance you could do me a step by step guide?
I do really appreciate all your help.
HI graemejones ,
You not need to modify your database, my suggestion do these operations on data model side.(create a calculated table to expand original date range)
Steps:
1. Use unique fields and two date fields to create a calculate table with expand records.
2. Create relationship between raw table and calculate table based on above unique field.
3. Use new table date field as axis, raw table amount fields as value to create visuals.
Regards,
Xiaoxin Sheng