Best Of

Re: Exporting Mega Tables

I believe it is a limitation with the Excel option when choosing Send/Export. I just tested with an mega table card that had 84k rows. When I chose Excel, it only exported 50k rows. When I chose CSV, I got all 84k rows.

MarkSnodgrass

2

Re: Charts/Graph by

@NIKKI

You should put your date column in the x axis then use the “trellis/tiered dates” chart property to include a trellis category. Then drag location over to the “category 2” field. I would recommend making location also be the series when you do this as well.

ST_Superman

2

Re: card design troubleshoot

@Jbrorby You can achieve this using a Stacked Bar + Line chart without the Trellis Settings. In order to stack the bars, you will need to create two separate beast modes for True and False values:

For true:

sum(case when test = 'True' then lte_ibd_transaction.net_shipment_count else 0 end)

For false:

sum(case when test = 'False' then lte_ibd_transaction.net_shipment_count else 0 end)

Then you can place both of these fields in the "Series" spot in Analyzer. In order to show the table below the graph like in your Excel version, check the box under Chart Properties > Data Table > Show Data Table

MichelleH

2