How to combine 2 cells in a table chart

I created a table card that inclues ID, category, lastmonth value, previousmonth value and % change. For each id, there are 2 categories, thus Id shows in both rows. I would like to combine the 2 rows for Id so that the ID only shows once. Can someone help me with it?

Thank you.

Olivia

table.png

Find more posts tagged with

Comments

BlueRooster

One option you have is to use the "Subtotal Row" field. Below is a screenshot where I believe I'm doing something similar to what you want:

Let me know if you any questions or issues.

Sincerely,

ValiantSpur

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Screen Shot 2018-08-14 at 3.49.46 PM.png

ST_Superman

I have a couple of thoughts on this one. Are you sure that you want a table card with only one row of data for each ID? If you are open to viewing this with a visualization, you can do so with one card and a quickfilter (or with two cards):

Otherwise, I think the easiest way to accomplish this in a table card is to use an ETL to "Uncollapse" the column:

Screen Shot 2018-08-14 at 3.49.46 PM.png

ST_Superman

Sorry, I just realized that I posted the TotalViews Card twice. Here is the AverageViewPercentage Card:

Screen Shot 2018-08-14 at 3.49.46 PM.png

Dennis_Ong

You can create a beast mode formula to split the amount into multiple rows. Sample Image attached.

Sample beast mode formula:

concat('<div style="text-align:center">','Actuals',
'<br/>','<br/>','Budget',
'<br/>','<br/>','% Ach',
'</div>')

Screen Shot 2018-08-14 at 3.49.46 PM.png