topic Re: Line Chart with more than 20 measures? in App Development

Line Chart with more than 20 measures?

curt1094 — Fri, 19 Jan 2024 18:56:13 GMT

Is it possible to have a Line Chart with more than 20 measures? I need to add a total of 30 measures to a line chart. If this is possible, how would I go about doing this?

Re: Line Chart with more than 20 measures?

anat — Sat, 20 Jan 2024 05:40:14 GMT

there is a limitation in line chart:

Dimensions	Measures	Result
1 dimension	1 measure	A simple line chart with a single line.
2 dimensions	1 measure	A line chart with the first dimension on the X-axis, and a line for each value of the second dimension.
1 dimension	up to 15 measures	A line chart with one line for each measure.

Re: Line Chart with more than 20 measures?

Rohan — Sat, 20 Jan 2024 05:57:44 GMT

Hi,

Though as these limitations be, We can always try to use Dummy Dimension as a loophole to tackle such scenarios. In this case, we will use 2 dimensions : Month & Dummy. in measure :

Pick(Dsort,Exp1,Exp2,Exp3,.....Exp30);

Dummy Dimension is nothing but an Unlinked Island Table with your desired Expression Labels & their Sorting Order. For your case, something like :

Dummy :

Load * Inline[

Dummy,Dsort

Exp1,1

Exp2,2

...

Exp30,30];

Try this & let me know.

Regards,

Rohan.

Re: Line Chart with more than 20 measures?

anat — Sat, 20 Jan 2024 12:46:40 GMT

Or else try to create like ad hoc report like display only those metrics based on selection