Hi Andy - I was watching a video of yours on how to compare similar products sold between two or more companies but my browser closed and I can't find the video. If this rings a bell you could please link me to it as it was really useful. Many thanks as always
Hey Andy, I have a query for you. If in place of Sales column we have a calculated measure which is already a sum/Average of any field. Then how to compare the selected value with others. As in that case, the calculation field will be showing error as we can't mix aggregation/ aggregate the values....etc. Can you please suggest some solution about it.
Hi ! I have a query. There are 4 different product levels - Category, Sub category, Brand and Sub brand. All the values within each of these columns would be displayed like a tree structure (where will be showing $, chg vs ly ) . I will have a pie chart showing $ share contribution below. Now, I want to build a functionality where if user clicks on any of the value in tree, the pie chart should show $ share contribution one level below. Ex, if user clicks Cereal as a category value then the pie chart should show all the sub categories with Cereal category. If user clicks Granola as a subcategory then the pie should show all the Brands within that. How can I do this?
You would need to use a set action, though a parameter action might work as well. Create a formula that takes the results from the top and then applies it to the bottom. For example (you'll need to write this properly): IF Top Chart = Category THEN Sub-Category ELSEIF Top Chart = Sub-Category then Brand etc
Question - when I dragged the value for selected sub-category to the columns, it does not show anything for the Art row, it's blank. How can I fix that?
Thank you!
As expected as always. Master with knowledge.
Thank you for sharing this. Awesome.
Thanks for this simple but powerful tip!!!
Very useful and awesome tip. Thank you.
Hi Andy - I was watching a video of yours on how to compare similar products sold between two or more companies but my browser closed and I can't find the video. If this rings a bell you could please link me to it as it was really useful. Many thanks as always
How about your browser history? I can't think of the name of it off the top of my head.
@@vizwiz I found it Andy, thanks. I left a question as a comment on the video I wonder if you could help with that? Thanks again
Hey Andy, I have a query for you. If in place of Sales column we have a calculated measure which is already a sum/Average of any field. Then how to compare the selected value with others. As in that case, the calculation field will be showing error as we can't mix aggregation/ aggregate the values....etc. Can you please suggest some solution about it.
If they are already aggregated, then the LOD will need to have the aggregation removed inside of the calculation.
Hi ! I have a query.
There are 4 different product levels - Category, Sub category, Brand and Sub brand. All the values within each of these columns would be displayed like a tree structure (where will be showing $, chg vs ly ) . I will have a pie chart showing $ share contribution below.
Now, I want to build a functionality where if user clicks on any of the value in tree, the pie chart should show $ share contribution one level below. Ex, if user clicks Cereal as a category value then the pie chart should show all the sub categories with Cereal category. If user clicks Granola as a subcategory then the pie should show all the Brands within that.
How can I do this?
You would need to use a set action, though a parameter action might work as well. Create a formula that takes the results from the top and then applies it to the bottom.
For example (you'll need to write this properly):
IF Top Chart = Category THEN Sub-Category
ELSEIF Top Chart = Sub-Category then Brand
etc
Question - when I dragged the value for selected sub-category to the columns, it does not show anything for the Art row, it's blank. How can I fix that?
Either 1) the calc isn’t correct or 2) there’s nothing in your parameter, therefore there is no value.
Thank you!
My pleasure