Several beginner questions

[Rodrigo Silva Cosme]

Hi everyone,

I am new to Superset so some of my questions may be easy to help with. In general I am extremely satisfied with the dashboard I created so congrats! Superset is amazing!

As a perfectionist, some small details that I couldn’t fix are bugging me. I am running Superset 0.15 on top of a MySQL database. I’ll list the details I need some help with below:

1. I created a table grouped by month to show a metric I created. Unfortunately by default the table is ordered by the metric so when I open my dashboard it’s ranked by the metric and not as a time series. I tried to use ordering by and edit the slice but it's still ordered by the metric.

   
   

2. I want to modify the name displayed on my slices when I use table columns (not metrics). I tried using Verbose Name editing my table columns but on my Slices still shows the database column name. The filter below is an example. It shows the database column names instead of the Verbose Name. Maybe that's not what Verbose Name on table columns are intended to behave, I guess. Is there a way for me to edit the name displayed on the Slices for every table column I have?

3. I am trying to format a Datetime that shows up in a table slice. I tried editing the column’s datetime format and database expression from the table (Sources → Tables → Edit record (Table) → Edit record (Column)) but it still shows as the database original formatting. I don’t think I understood what Datetime Format and Database Expression purposes so I probably did not use it correctly.

   : /

4. I have a statistics slice (Table) where I use some metrics to display the performance of the process from the dashboard. This table only has one row since I am taking all rows from the database and calculating some statistics. By default each metric I add is displayed as a new column. Unfortunately that does not fit well on my dashboard visually. I would like to transpose my table but I don’t think that’s possible right now. Is there a way for me to customize my Table (Slice) orientation and transpose it?

5. Every Table I created comes with a horizontal scrollbar. It does not matter if there’s enough space for the info to be displayed, the scrollbar is still there. It shows on the dashboard as well. Is there a way to change that? On the first topic image is an example, that horizontal scrollbar on the table.

6. This one is trickier and probably too specific to the use I intend for this Slice. I plot an area chart showing the performance of today’s shift (starting at 9am). I do a cumulative sum of the results and plot it. The problem is that my Slice does not begin at 9 a.m. with 0 since there is no record at 9 am with 0 result. I don’t know how this could be done but is probably very specific to what I’m doing but if there were a way to begin a cumulative sum from a specific value at a specific time would be amazing.

   
   

Best regards,

Rodrigo Cosme