Forum Discussion
Merge two Visuals
Number of itemsValue of Items
Hi Guys,
I am trying to merge two visuals into one, is this possible? Date is a common value between the two.
Not sure where to start and how could i end up with a stacked column that displays btoh number of items along with values outstanding for a distinct days?
Thanks
Hi Junaid72,
Suppose your source table structure is similar to:
Please insert a clustered and column bar chart, please field [Day] (or may be date hierarchy in your scenario) into "Axis" section. Then, drag [item] with "Count" aggregation and [value] with "Sum" aggregation into "Value" section.
Best regards,
Yuliana Gu
1 Reply
Hi Junaid72,
Suppose your source table structure is similar to:
Please insert a clustered and column bar chart, please field [Day] (or may be date hierarchy in your scenario) into "Axis" section. Then, drag [item] with "Count" aggregation and [value] with "Sum" aggregation into "Value" section.
Best regards,
Yuliana Gu