Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to put 2 measures in a graph. These are number of tickets and budget of tickets (what we expect). The number of tickets are in a table and the dimension is weeks_left_to_event which ends up in the present. The budget fields are in another table whose field I want to use as a dimension is budget_weeks_left_to_event.
Is there a way to share the dimension as I would want both lines in a graph?
Many thanks!!
Hi,
You will have to load the fact table twice & concatenate both the week fields into a single field. Then use this new Week field & your measures in the Line graph.
Regards,
Rohan.
Hi Rohan!!
I didn't understand well. How would you do it?
These are the 2 tables:
Hi Rohan, many thanks for your answers
I tried that before but I need some other fields from the fact table in the budget rows as event_name, event_year, event_to_compare... so that the rows with the budget are not very empty. maybe I should do a left join before, with only these (dimension) fields form the big table, and then concatenate as you said.
Thanks again
I will try this:
I suspect it won't give the desired output. Hope it works out for you
Regards,
Rohan.
yeah it only gives the budget fields. Very weird.
Thank you for your help anyways