topic Re: Plot columns on x-axis in line chart (without cross table) in Visualization and Usability

Plot columns on x-axis in line chart (without cross table)

johnnyjohn — Thu, 09 Feb 2023 08:02:20 GMT

Hi,

I'm looking for a way to show data as seen on the line chart below, where x-axis has the different times.

The raw data table has the values as columns, while the line chart has these values as x-axis, where the values for each time is average over the order IDs.

The line chart was done with a cross table, but I essentially need to create 16 of those crosstable to look at different data attributes.

I'm looking for a way to accomplish the same thing without creating additional tables. Any ideas?

Re: Plot columns on x-axis in line chart (without cross table)

vinieme12 — Thu, 09 Feb 2023 09:33:43 GMT

life will be easier with the Time dimension as row values instead of columns

I'd suggest using crosstable load

or else you will have to write an expression for each time value column!

Re: Plot columns on x-axis in line chart (without cross table)

johnnyjohn — Thu, 09 Feb 2023 10:04:45 GMT

Hey. So I have used the crosstable load (you can see on the pic, the table on the right is the data of the crosstable and the graph uses that data). My question was how you would do it without using a cross table / creating a new table. How would you do it with an expression for each time?

Re: Plot columns on x-axis in line chart (without cross table)

vinieme12 — Thu, 09 Feb 2023 10:19:39 GMT

Create a Dummy Dimension, example below

tempTime:

//Using Dual() for sorting the dimension on numeric value

Load Dual(TIME_Axis,recno()) as TIME_Axis Inline [

TIME_Axis

10m

15m

20m

];

In Charts add measure as below

Dimension

TIME_Axis

Measure

=Pick( TIME_Axis

, sum(1m)

, sum(5m)

, sum(10m)

, sum(15m)

, sum(20m)

)

Re: Plot columns on x-axis in line chart (without cross table)

johnnyjohn — Thu, 09 Feb 2023 10:26:28 GMT

That would create an additional though wouldn't it (tempTime)? I'm looking for a way that doesnt need a new table to be created. I have 16 different type of tables like I need to show and need want to avoid creating new tables for each.

Re: Plot columns on x-axis in line chart (without cross table)

vinieme12 — Thu, 09 Feb 2023 10:48:04 GMT

It's just a dimension column!

You can replace it with a valuelist() dimension

Dimension

=Valuelist ('1m','5m','10m','15m','20m')

Measure

=If ( Valuelist ('1m','5m','10m','15m','20m')='1m' , sum(1m)

,If ( Valuelist ('1m','5m','10m','15m','20m')='5m' , sum(5m). ....... And so on for each