topic Re: chart columns in App Development

chart columns

joeybird — Fri, 08 Jan 2016 12:09:02 GMT

Hiya

I have two main columns of use in a table of Orders

CustomerID, and OrderID

I am using CustomerID as a dimension, for how long each customer order takes, but I have to use OrderID, as a dimension, because each bar will group each CustomerID totals.

I want to show CustomerID lables not OrderID lables on my dimension

I know this will show two or more instances on the dimension axis of CustomerID, but this is what I require

please help.

Re: chart columns

ogster1974 — Fri, 08 Jan 2016 13:29:34 GMT

I've had a look at the options in piviots and straight tables. You cannot set the label dynamically so setting the label to CustomerId on the ordered dimension is out.

Aggregating the measure also doesn't cause the dimension to split out along the lines you need either.

There is no way to hide dimension although you can order the least import ones at the end of your table.

One way you might want is to use a master items drill down so it starts at Customer then clicking on it gives you the detail at order level but again doesn't satisfy your exact brief.

As you allude to its not an obvious request to have to satisfy.

Re: chart columns

joeybird — Fri, 08 Jan 2016 14:08:07 GMT

Hiya

thank you for your help, it has helped

Kind Regards