Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kaushi2020
Creator II
Creator II

Bar chart

Dear all, 

If you see the bar chart and line chart, the bars and data points are not in sync - means the alignment of the data is not correct in terms of presentation. (No data issue)

Expectation is that the bars should cover the full space (right side empty space in below image) same as the line chart instead of showing empty spaces on the right side.

kaushi2020_0-1702449923190.png

Expression for bar chart:

(Count({$<Year=, Month=, Day=,Contact_Center={'Digital'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))

 

Expression for Line chart (below the bar chart):

((count({$<Year=, Month=, Day=,Contact_Center={'Digital'},HandlingTime={">0"},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
SequenceID))

/

((Count({$<Year=, Month=, Day=,Contact_Center={'Digital'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Distinct AgentID))))

 

thanks in advance.

 

Labels (5)
1 Solution

Accepted Solutions
F_B
Creator III
Creator III

Hi,

yes, I know, this is something that can be improved in visualization options, but just play around with the following settings and you'll get it: 

*Bar chart properties

*X-axis 

*Number of bars

*Custom

Hope this helps,

bye

View solution in original post

4 Replies
F_B
Creator III
Creator III

Hi,

yes, I know, this is something that can be improved in visualization options, but just play around with the following settings and you'll get it: 

*Bar chart properties

*X-axis 

*Number of bars

*Custom

Hope this helps,

bye

kaushi2020
Creator II
Creator II
Author

thanks for the reply. by changing below ones was able to achieve the ask.

kaushi2020_0-1702468585839.png

 

kaushi2020
Creator II
Creator II
Author

just checked when Day = 1. below is how the graph is show. if i reduce the width - it will not work as it will impact all the other days bar length. any suggestions ? 

kaushi2020_0-1702473447079.png

 

F_B
Creator III
Creator III

Unfortunately, when the number of bars is less than the max value set, the visualization adapts, and I'm facing the same effect in a few apps. I haven't found any properties settings to avoid it yet, maybe it's worth browsing into Ideation?