I built a Table (Report) that compares KPIs Month to Date and Last month, they are set up in Looker as ‘Periods’ for comparison. I then visualize the data in a Table (Report) and transpose to get the periods as columns and KPIs as rows. The data coming from the visualization and data are in black and I’ve represented it in an excel table for demonstration purposes. So to reiterate what is in black exists today in the table. I want to do 2 things. I want to compare the 2 columns to each other (in red) - i.e. how is Month to Date doing against last month, AND introduce a static Goal KPI and compare Month to Date to that as well.
How would I build that to show in this table as I want in the excel demonstration?
Thank you, Andrew