r/GoogleDataStudio

How have you addressed this problem?

I feel like I'm taking crazy pills. When creating a pivot table that has dimensions in the columns and metrics, this little title generates in the upper right corner. For the life of me, I cannot find a way to remove it.

It's not really communicating anything new; it's just taking up space.

https://preview.redd.it/7nifwsdsbc2h1.png?width=269&format=png&auto=webp&s=5931071be123477866f27bb099bdde580473eb55

Is it just not an option to hide or remove? Or am I missing something. Been seeing posts about a "remove header" option in the style page, but I see nothing. Chart Title is just for the entire chart, not that piece. Anyone have any thoughts?

Hello. I want to eventually create a run chart plotting deltas of survey scores for client at different stages when only a paired sample exists.

There are four fields relevant to this chart.

Client_ID (Text)
Client_Progress (Text) - Options are "Admission, Discharge, Six-Months"
CM-1N (Value) - a score between 0 and 4 (from a Likert scale SD/D/A/SA)
SURVEY_DATE

So, I first only want paired samples to compare admission vs discharge scores and want to calculate a delta between the two per client when only a pared example exists and plot the average of the deltas from all the paired samples on a monthly run chart.

I created a pivot table visualizing the data and you can see all the rows where there are nulls for either admission or discharge conditions of client-progress.

https://preview.redd.it/51412730w42h1.png?width=1217&format=png&auto=webp&s=d30d01250965de21fdd2d27de62ec8b978d52dab

What would be the best way of doing this? Should I create a new blend of same table multiple times with Client_ID, Client_Progress and CM-1N score? If so how would I create the delta calculated metric? I have tried a couple variations but seem to get stuck on ensuring that both an admission/discharge progress value exists condition for each client.

I am relatively new to this and appreciate your thoughts and guidance... maybe there is a simpler way of looking at this that I cannot see.

Also too bad that pivot tables cannot allow to create a calculated column based on previous columns on the table. But I would assume that If I can get the run chart working the pivot table will be easy to create with the new calculated field(s) on the new blended data.

Screengrab picture attached.

Thanks for your help!

I have multiple date columns in my dataset. I want the date range control to affect a specific date dimension. Basically how to change the default date dimension column.