Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
GiuQlik7
Contributor II
Contributor II

Problems in the definition of a grouped bar chart in combined chart

Hello,

I have a simple database like the following: 

DetailDay1Day2Day3Day4Day5Day6Day7
TOTAL796901.2949191.2981.5211.697
of which A3848786855682610091133
of which B41203426363472512564

 

and I used a crosstable to define week distribution:

crosstable (Week_Dett, Distribution_Dett,1)
LOAD *
FROM #TABLE#;

I would like to get a combined chart like the following:

example.jpg

 

 

 

 

 

 

 

 

I tried to insert Week_dett like dimension, I added Detail as alternative dimensions and Distribution_Dett as measure, but my result is terrible:

Untitled.png

 

 

 

 

Can you help me, please?

 

Thank you! 🙂 

 

 

Labels (1)
1 Reply
Jerry_Jin
Former Employee
Former Employee

Hi - I think this can be accomplished by using a Combo Chart by inserting Week_dett as a dimension, and everything else as Measures. And then change the Total from bars to lines!