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.
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?
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:
what you can suggest me?
or i have made concatenation this values into sqllite string in one column, such as:
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