Helena_qbeeq
Cloud Apps
Joined 12-16-2022
User Profile
User Widgets
Contributions
Re: How to create an average line in a bar chart?
Hi lalasisi , You can achieve this by creating a line chart, adding an additional measure that will calculate the average, and changing the chart type for the Cost to column. Here is the formula to get the average: And the final result: Please let me know if this works for you : ) Always here to help, Helena from QBeeQ [email protected] QBeeQ - Gold Implementation and Development PartnerRe: Applied JAQL formula on top of another JAQL formula result
Hi enmiwong , That would be the dimension that differentiates each row. Similar to a group by. What kind of filters would you like to implement? On the formula itself? on the widget? on the dashboard? Always here to help, Helena from QBeeQ [email protected] QBeeQ - Gold Implementation and Development PartnerRe: Applied JAQL formula on top of another JAQL formula result
Hi enmiwong , If I understand your question correctly, in the third column you would like to get the maximum value previously obtained on the rows. Have you tried using multi-pass aggregation? In your example, it would look like this: MAX(DIMENSION_IN_FIRST_COLUMN, (10 * MAX([sepal_length]) + 0)) I am attaching an example based on the eCommerce sample data. Please let me know if this works for you. Always here to help, Helena from QBeeQ [email protected] QBeeQ - Gold Implementation and Development PartnerRe: Coloring on a bar graph
Hi andyjohnston , If the objective is to have different colors for each bar, have you tried a script similar to this one? This might be a solution. Please let me know if this works for you : ) Always here to help, Helena from QBeeQ [email protected] QBeeQ - Gold Implementation and Development Partner
