dimensions and their calculations are as follows
Create date : if(cr=1 ,cr_date, dr_date)
Expiry_date : if(exp=1,a_exp_date,b_exp_date)
Completion Date : work_completion date
And I have 3 measures:
count(document_id)
count(if(cr=1,document_id))
count(if(exp=1,document_id))
I want to create combo bar chart where x axis is date .And it should be union of all these dates.I need to show these measures on the same chart.
Please help me on this.
Hi,
try to upload a data sample
Regards,
YB