Hello, I had a nice waterfall chart that worked perfectly with conditional formatting and all.
However, now we have upgraded to 1.6 (SP3) the formatting no longer works. Most of the threads that I have read say the answer is to switch to the waterfall chart from the Info Chart option. This I have done but, my issue is that the new chart only picks up the first key figure from my data source - please note that I am actually using a structure with seven key figures to populate my chart rather than one key figure with a month drilldown for example.
Does anyone have any advice on how to include all of my key figures because it doesn't seem obvious in the chart configuration or any of the training material.
I think your issue might be related to a problem I was also having a couple of weeks ago, albeit with a different chart type. I think what you are experiencing is related to how InfoCharts now link data sources to display what is a measure and what is a dimension. You mention you have seven key figures instead of one key figure and drill down - so I can assume, you want to treat your seven key figures as dimensions, but DS won't let you do it. This is exactly how I like (and in many cases, need) to structure my data sources as well, which seems to now cause a lot of problems in the new InfoCharts, which dumbly decide for you what you want to show on your chart. If you switch your chart type to, for example, columns, you will probably see that DS is treating your key figures as separate series of different colours and will put them in the legend. It will also display just one key figure in, for example, pie chart, ignoring other key figures entirely.
Unfortunately, there is no easy way around it. You can read the following thread to see what my problem was and how I eventually managed to bend my BW query to trick Design Studio to see the data correctly. You may need to do something similar to trick your InfoChart:
If you send me a screenshot of your data source (if it's a BW query) I could try to see if I can figure something out.
Hello Agata, thank you for your response.
Yes I considered that by introducing the key figure names as actual characteristic values and combining my key figures results into one that could then be split out by this new characteristic but, this will require back end work. which I really want to avoid as a parts of my calculations need to be done in Bex. The query view is here - waterfall-query.jpg but, it is only the key figures that I want to appear in my chart nothing more so, I think that I may be frustrated. Any assistance you could offer would be greatly appreciated.