Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create new table with measures based on different (fixed) time periods

Hi guys,

 

I am working on a dashboard right now in whichI want to display several different KPI's over different time periods. At the moment, I'm doing this using the visual "Card with States by OKViz". As there are 5 different measures right now (could be more in the future) and 3 time periods, I need 15 visuals. I have the feeling that this might be increasing the load time when filtering through the dashboard. Below is a screenshot of how it is set up right now. As you can see, I want to show the measures based on 'Lifetime', 'Yesterday' and 'Today' data.

 

So, I'm thinking of turning this part of the dashboard into a table, or a 'KPI grid' so there's only 1 visual that has to be loaded. However, I can't seem to create a dimension that displays all 3 date dimensions. Mostly because they overlap (Lifetime contains both Today and Yesterday). If this wasn't the case, I could just create a separate column in my date table.

 

Is there a way to get these periods in as a dimension to use in a KPI grid, or maybe create a new (calculated) table that shows all of this information and just display that whole table?

3 Replies