if you need one chart with 2 graphs and x axis day of week and y axis amount, but you table configuration looks like id column,this Monday column with amount in row, last Monday column with amount in row, thisThuesday column with amount in row , last Tuesday column and amount in row and rest days of this week and last week for each id.
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
jesse
2
There is a pivot table visualization built-in to Redash. Have you tried this?
Can you share an example of the data you want to visualize? Have you managed to make a similar visualization in another tool? Can you sketch it?
viktoria
3
There are two possible ways: First i have a lot of columns with data for many ids and i want visualize some columns like one graph with y values 34;56;45;45;76;65;0 with x axis feature 1,feature2, feature 3, feature 4, feature 5, feature 6, feature 7:for example:
id1, feature 1,feature2, feature 3, feature 4, feature 5, feature 6, feature 7:
320000000;34;56;45;45;76;65;0
what you can suggest me?
or i have made concatenation this values into sqllite string in one column, such as:
id1, column2:
320000000;‘34;56;45;45;76;65;0’
and next step create some column2 with numbers for making graph with y axis values like in column2 like when i have chosen id 320000000
column2:
34;
56;
45;
45;
76;
65;
0