Flex Table with only one column

Reply
Highlighted
Green Belt

Flex Table with only one column

How do I make a flex table with only one column? I don't want more than one columns, but it seems that the flex table input needs at least two columns to work. Could anyone help?

 

If not, then I was thinking of using a Comparitive Guage as an alternative. However, I cannot make the beast mode calculation as per my needs to work on a Comparative Guage. Here's the two columns I have to use:

 

Date: Shows date of purchase

Product ID: Shows product ID of sold product

 

Note: Product IDs can be repeated becaue same product IDs can be sold more than one time. 

 

I have a date filter on my dashboard. Through the presets mode, I can choose any weekly time range: last week, last 2 weeks,  last 3 weeks etc. 

I want the comparative guage (another card on dashboard) to show the difference between the number of product IDs sold during the last date and the latest date. 

 

I can do this easily with a flex table, but for that I need more than one column. 

 

Comparative guage asks me for previous value and new value. I dont understand how to make a beast mode calculation that takes the distinct product ids for the oldest date selected, and the latest one. Here's my best guess:

 

Previous value: Count ( Distinct ( Case when 'date' = min('date') then 'Product ID'))

Latest value: Count ( Distinct ( Case when 'date' = max('date') then 'Product ID'))

 

But this does not work. I think because min('date') is the same date for that row. 

 

Any help?

Highlighted
Green Belt

Re: Flex Table with only one column

Hi @hamza_123 ,

 

Did you try making them making hidden? I suggest you to add multiple columns in table and mark them hidden from general properties window. Make just one column visible.

 

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

 

Thanks,

Neeti

Tags (2)
Highlighted
Blue Belt

Re: Flex Table with only one column

@hamza_123 

 

Which column are you attempting to hide? If you want to Hide a column in the flex table you can do this under General settings by selecting Empty from the drop down for the Column #.

 

You can't utilize a beast mode to do this because the beast mode will look at each row individually. You'd need to calculate the min and max in an ETL before it gets to the card.



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
Green Belt

Re: Flex Table with only one column

A column appears as a row in the flex table. So i'm trying to hide a rown in the flex table. 

Highlighted
Blue Belt

Re: Flex Table with only one column

Can you filter that value out via the card filters?



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
Green Belt

Re: Flex Table with only one column

No I cannot

Highlighted
Green Belt

Re: Flex Table with only one column

Hi @hamza_123 ,

 

I had a similiar issue in past and I have written a beast mode, and changed the color of column which is a row now. It was somthing like, check if value is 'static_column_name' then change color.

 

Since beast mode works row wise, I suggest you to give a try based on your static column name(which is a row now). 

 

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

 

Thanks,

Neeti

Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!