topic Re: Top 6 By Month in Chart in App Development

Top 6 By Month in Chart

brcovenantpp — Wed, 27 Jul 2022 21:05:06 GMT

I have a bar chart with 1 dimension and 1 measure, by month. I want to show the top 6 dimensions(Total sales) for each month. I know you can use the top/bottom buttons with an expression defining the amount you want. Want I want to try to do is conditionally format dimensions that weren't in the previous month's top 6. So if a new dimension enters the top 6 in June, and wasn't in the top 6 in May, it's bar is colored red. Not sure if this can be done, but any help would be greatly appreciated. Thank you.

Re: Top 6 By Month in Chart

sidhiq91 — Thu, 28 Jul 2022 03:59:47 GMT

@brcovenantpp Could you please provide some data and also the expected output that you are looking for.

Re: Top 6 By Month in Chart

brcovenantpp — Thu, 28 Jul 2022 16:42:17 GMT

This is one of my charts. What I'd like to do is, if one of the columns isn't present in the previous quarter's top 6, add a conditional format that would color the bar red to indicate it's new to the top 6.