16 Replies Latest reply: Mar 24, 2014 2:00 AM by Ramkumar Ramagopalan

# listbox mini chart

hi,everybody.

i have a question for this,how can i do like that:

• ###### Re: listbox mini chart

you may write an expression in list box and define it as mini chart.

Then you can even customize your mini chart for bar, line , guage etc.

• ###### Re: listbox mini chart

Thank you very much

but when i try this ,it's like that:

• ###### Re: listbox mini chart

Hi,

Can you attach sample file?

Regards,

jagan.

• ###### Re: listbox mini chart

hi, jagan.

sorry ,i can't find where i can attach the file.

Data like that:

SHOP, BRAND, PLU, Amount
S1, B1, P1, 5000.30
S2, B1, P1, 6429.29
S2, B3, P2, 3400.29
S3, B2, P4, 7200.01
S4, B2, P3, 2300.80
S4, B4, P1, 6500.23
];

• ###### Re: Re: listbox mini chart

Thanks,

Ram

• ###### Re: Re: listbox mini chart

hi,

the simple data :

SHOP, BRAND, PLU, Amount
S1, B1, P1, 5000.30
S2, B1, P1, 6429.29
S2, B3, P2, 3400.29
S3, B2, P4, 7200.01
S4, B2, P3, 2300.80
S4, B4, P1, 6500.23
];

Best Regars,

Harry

• ###### Re: Re: listbox mini chart

PFA.

Thanks,

Ram

• ###### Re: Re: Re: listbox mini chart

See the screenshot.

• ###### Re: listbox mini chart

Hi, Ram

thanks!

i can't open the attach file.

How do you do that~

Best Regards,

Harry

• ###### Re: Re: Re: listbox mini chart

no worries. Have a list box based on SHOP and then add 2 expressions.

1st expression is simple. Sum(Amount)

2nd expression is Sum(Amount)/Max(Total Aggr(Sum(Amount),SHOP))

Make the representation as Linear Guage

Goto Gauge settings, delete Segment 2.

Choose mode to "Fill to Value"

Deselect "Show Scale"

Let me know if you have issues.

• ###### Re: listbox mini chart

Hi,

Thank you very much,

but when i choose  one shop

it's like that:

Best Regards,

Harry

• ###### Re: listbox mini chart

Hi,

i find a way ,

i defined the max value:

Max({\$<SHOP = >} Aggr(Sum({\$<SHOP = >}Amount),SHOP))

and Expression:Sum({\$<SHOP = >}Amount)

thank you very much

Best Regards,

Harry

• ###### Re: listbox mini chart

I was about to send you something similar. But your solution is very good.

• ###### Re: Re: listbox mini chart

Hi,

Regards,

Jagan.

• ###### Re: listbox mini chart

Hi,

Create two expressions in Expression tab and select 1 expression as Text in 'Representation' listbox and another as Linear Gauge.

Regards,

Jagan.

• ###### Re: listbox mini chart

Hi,

and expression is: sum({\$<SHOP =>} Amount)