Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Got terribly stuck with a situation. I have a data-set in excel in the following format:
Date | Coal | Hydro | Solar | Wind |
1-Jan-17 | 130 | 250 | 336 | 404 |
1-Feb-17 | 128 | 219 | 327 | 423 |
1-Mar-17 | 156 | 287 | 375 | 454 |
1-Apr-17 | 133 | 253 | 389 | 452 |
1-May-17 | 171 | 253 | 305 | 469 |
1-Jun-17 | 138 | 251 | 347 | 430 |
1-Jul-17 | 191 | 279 | 312 | 474 |
I have created a stacked Bar chart out of this data, with each field (i.e. Coal, Hydro, Solar & Wind) appearing in different colors. Now I would like to have a list box with all these 4 field names. And once, I select a particular fueltype, the bar chart only displays data for that particular fuel. Thanks a ton for your help in advance.
Hi Anand,
See Attachment.
Regards,
Antonio
thank you very much Antonio for this as it is very helpful. Couple of questions here:
1. Under the Expressions - -> Conditional Check Box you have entered a formula as: SubStringCount(Concat(Fuel,' '),'Coal'). What does this mean here and what is the condition based on the count of fuel type occurrence?
2. In the inline statement, you have mentioned:
LOAD * Inline [
Fuel
Coal
Hydro
Solar
Wind];
Does it mean that Inline table created can be referred by the first entry, i.e. 'Fuel' anywhere (like you have used it in Listbox Field?
Thanks again, Anand
Hi Anand,
1) Condition is : text 'Coal' is in the selected Field/s Fuel.
2) 'Fuel' is Field Name. Colar,Hydro,Solar,Wind are values of Field 'Fuel'
Regards,
Antonio
Thanks for your prompt reply Antonio. and sorry to be naive there, but I thought SubStringCount(Concat(Fuel,' '),'Coal') function will return a number "1" in this case as coal would be appearing once in the list. How does 1 here translates to that the condition is met? Does 1 or any value more than 1 signifies 'TRUE' here? thanks, Anand
More specifically condition is 0 or <> 0
Just as if You wrote
=If(SubStringCount(Concat(Fuel,'|'),'Coal') > 0,1,0)
sure thing Antonio. thanks a ton for the explanation. anand